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 “replevy” 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.

114 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
replevy153347(None) 
releve95116402re_leve
replay113412922repl_ay
replead10399012replead
repled93319782reple_d
replete92912992replete
replevin1365052replevin
reply104015852repl__y
celery1139623ce_lery
crepey135110933crep_e_y
deplete103010423deplete
deploy1237583depl_oy
elegy939303_e_legy
hellery13329213hellery
henley1237483henle_y
kreplech1941583kreplech
levy106418503___levy
medley1298343medle_y
pedlery13297083pedlery
peppery13286253peppery
realer63528593reale_r
reales64934123reale_s
realest73322433realest
reality10313573reality
really93315613real_ly
realty92713693real_ty
reblend1036653reblend
reblent9614253reblent
reclean938523reclean
redefy13388763re_defy
redeny102712733re_deny
redleg839273redle_g
redlegs936823redlegs
redly94217203redl__y
reedy910020293re__edy
reefy114217703re__efy
reeky125416263re__eky
reelect911515633reelect
reeled74725533reele_d
reeler63822573reele_r
reelers73520273reelers
reeve84121323re__eve
reflect123913713reflect
reflet94024233refle_t
reflets103513153reflets
reflew12389453refle_w
reflex16359513refle_x
reflexly2142463reflexly
refly113914563refl__y
reglet73724233regle_t
reglets83512983reglets
rekey124014733re_ke_y
relay84424673re_l_ay
relend76116453re_lend
relent64431853re_lent
relet54749823re_le_t
relets64025673re_lets
releves103914973re_leves
relieve105010693relieve
relievo10425773relievo
relive95120783re_live
relleno796463relleno
rely75428953re_l__y
remedy1237873re_medy
repave114813873rep_ave
repaved133311133repaved
repaves123513653repaves
repay104818453rep__ay
repeal84718283rep_eal
repeat85127213rep_eat
repeg84015053rep_e_g
repegs93311943rep_egs
repel74921403rep_e_l
repels84318763rep_els
repent84728873rep_ent
reperk122511773rep_erk
replace113214283replace
replan83215823repl_an
replans92814943replans
replant93318533replant
replate93420053replate
replays12399763replays
repleads11357213repleads
repledge1243773repledge
repletely1443313repletely
repletes102812473repletes
replevied1574373replevied
replevies1465493replevies
replevins1465203replevins
replevying1953273replevying
replica1137943replica
replied103914463replied
replier94214973replier
repliers103710163repliers
replies94521043replies
replot83818593repl_ot
replots93412633replots
replow114210343repl_ow
replows12329703replows
replumb1343393replumb
repped114616723reppe_d
repress92712683repress
reprieve1375443reprieve
reprove122911073reprove
revelry1335693revelry
revery124014213re_very
ridley10169543ridle_y
riflery13345803riflery
riley84420583r_ile_y
ripely112511153rip_ely
ropery114313873rop_ery
ropey106021873rop_e_y
sealery104011053sealery
tepefy1434803tep_efy

Search took 9 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271148.20316338.8
3Display Results1141140.0462478.3
 (SQL Overall)1786911148.67220605.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.