Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “tepefy” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

204 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
tepefy143480(None) 
beefy135313832be_efy
redefy13388762redefy
reefy114217702re_efy
stupefy1542902stupefy
teeny85417882te_eny
tepee74724212tepe_e
tepees84215242tepees
tepoy10312162tep_oy
tumefy1434222tumefy
typey135511882type_y
typify1734522typify
aerify122810113aerify
apery106517903_apery
beef96233683be_ef_
beefs105618563be_efs
beery105220123be_ery
bereft114317303bereft
casefy1436273casefy
celery1139623celery
cepe84926653cepe__
cepes94424463cepe_s
crepey135110933crepe_y
deedy104315893de_edy
deeply1257013deeply
defy114921263__defy
deify124112763de_ify
depend103510923depend
deperm1139363deperm
deploy1237583deploy
deputy12426713deputy
dopey116020353dope_y
dupery12378743dupery
edify12308563_edify
eely77725213_e_ely
eery76129623_e_ery
elegy939303_elegy
emery104814333_emery
empery1348683empery
enemy1059993_enemy
epee64628503_epe_e
epees75219833_epees
epoxy17465773_epoxy
every115215453_every
geeky134710733ge_eky
hereby14468333hereby
heresy125011233heresy
japery18439143japery
keef115829993ke_ef_
keefs125116283ke_efs
leafy116316213le_afy
leery85919133le_ery
leper74820743lepe_r
lepers84817323lepers
merely111312583merely
mopery135210973mopery
mopey124821823mope_y
napery11489813napery
needy94614693ne_edy
nepeta837893nepeta
papery134812743papery
peery105719443pe_ery
peppery13286243peppery
peppy114310363pep_py
popery134511703popery
rarefy12296343rarefy
redeny102712733redeny
reedy910020283re_edy
reef74938213re_ef_
reefs85121663re_efs
reeky125416263re_eky
reify114814973re_ify
rekey124014733reke_y
remedy1237863remedy
repay104818453rep_ay
repeal84718283repeal
repeat85127213repeat
repeg84015053repe_g
repegs93311943repegs
repel74921403repe_l
repels84318763repels
repent84728873repent
reperk122511773reperk
replay113412923replay
replevy1533463replevy
reply104015853rep_ly
revery124014213revery
ripely112511153ripely
ropery114313873ropery
ropey106021873rope_y
seedy94821533se_edy
seely84522633se_ely
seepy104717973se_epy
sepoy10314303sep_oy
speedy1218410783speedy
steely93612573ste_ely
steeply1236293steeply
taffy145110823t_affy
tamely113711953tamely
tape64538143tape__
taped85327423tape_d
taper74829773tape_r
tapers84025813tapers
tapes75838603tape_s
tapeta8310693tapeta
teapoy1138113teapoy
teary85124053te_ary
techy135612013te_chy
teddy10489493te_ddy
tee38366873te_e__
teed55439263te_e_d
teel46335803te_e_l
teels55726373te_els
teem66132603te_e_m
teems76019783te_ems
teen45938203te_e_n
teens56227483te_ens
teensy9478273teensy
teepee8314363teepee
teepees939263teepees
tees45353583te_e_s
teeth87315853te_eth
teff106023763t__eff
teffs115111733te_ffs
tele45040873tele__
teledu737303teledu
telefax1743203telefax
telega736773telega
teles54536003tele_s
telex125214823tele_x
telfer9379893telfer
telly84920823te_lly
temped113912893tempe_d
tempeh13357463tempe_h
tempehs14325153tempehs
temper103914093tempe_r
tempera11329043tempera
tempers113513013tempers
tempest1139223tempest
tenet55542213tene_t
tenets65518953tenets
tenpenny1342343tenpenny
tensely1037363tensely
tenty86121603te_nty
tepa66021683tep__a
tepal76319583tep_al
tepals85415043tepals
tepas76521683tep_as
tepefied1444573tepefied
tepefies1346893tepefies
tepefying1843233tepefying
tephra1136483tephra
tepid8314313tep_id
tepidly1334403tepidly
tepoys1137543tepoys
teredo7310783teredo
terefah1344113terefah
terete6319333terete
termly1138433termly
terpene92310853terpene
terrify1336353terrify
terry84721873te_rry
tersely1038103tersely
testify13246943testify
testy85419063te_sty
tetany959843tetany
tetchy1436003tetchy
tewed94718533tewe_d
theft114118133t_heft
thereby1534633thereby
thewy146311853t_hewy
they107223753t_he_y
thief114516303thief_
timely113410113timely
tipoff1436383tipoff
tippy125411793tip_py
tipsy106010503tip_sy
toffy145310283t_offy
toney86027413tone_y
tope65946383tope__
toped85631313tope_d
topee76029953tope_e
topees85519703topees
toper75231023tope_r
topers85025323topers
topes76941763tope_s
torrefy1353353torrefy
towery124012093towery
tref77030993t_ref_
trey77228793t_re_y
tupelo836483tupelo
turfy114315403t_urfy
tweedy13455933tweedy
tweeny12477003tweeny
type96223743type__
typed115815453type_d
types105721063type_s
typy126013043typ__y
veery115816253ve_ery
venery123710663venery
verify153110163verify
weedy125115003we_edy
weeny115316163we_eny
weepy134212593we_epy

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.1431249587.4
2DLD Change Limit1127162045.07622205.7
3Display Results2042040.0633238.1
 (SQL Overall)1786912045.28233830.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.