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

121 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
devilry143397(None) 
deviltry1542981deviltry
devil94714732devil__
deviled124112182deviled
devils104412812devil_s
dewily1338342dewil_y
evilly1236592_evilly
revelry1335692revelry
aerily93017013aeril_y
aviary12338413_aviary
breviary1642623breviary
cavalry1554963cavalry
civilly1535483civilly
daily95922333d_ail_y
dairy97016303d_ai_ry
deadly113811473deadl_y
deafly13389123deafl_y
deair65817193deai_r_
deairs74013783deai_rs
deanery1137613deanery
dearly104615323dearl_y
deary95826843de__ary
debility1448643debility
deciare10710663deciare
decile94619213decil_e
deciles104417723deciles
decry115514353de__cry
decury1277963de_cury
deeply1257013deepl_y
defier105118653defier_
defiers113913993defiers
defile105216663defil_e
defiled124013103defiled
defiler113911883defiler
defilers12439473defilers
defiles114016843defiles
deftly1336533deftl_y
deify124112763de_i_fy
deil56231623de_il__
deils65722863de_il_s
deity94316773de_i_ty
delay94820633de__lay
delivery15286553delivery
delly96023873de__lly
denary105316863de_nary
denier74420693denier_
deniers84515183deniers
deploy1237583de_ploy
derisory1245163derisory
derry94721373de__rry
descry1256183de_scry
desire7415303desi_re
devalue1136013devalue
devel94217123devel__
develed123611933develed
develop13145033develop
devels104313903devel_s
deviancy1754183deviancy
deviant11311313deviant
deviate11312713deviate
deviatory1666453deviatory
device124512163devi_ce
devices133212583devices
deviling1311812853deviling
devilish1546373devilish
devilkin1642953devilkin
devilled1336743devilled
devilries1345253devilries
devious1138523devious
devisal1136913devisal
devise104215753devi_se
devised123712563devised
devisee113812713devisee
deviser114212393deviser
devisers12339863devisers
devises114116763devises
devisor11357043devisor
devisors12347253devisors
devitrify1941963devitrify
devoir1076033devoir_
devoirs1175783devoirs
devolve14316063devolve
devour1076703devour_
devours1166643devours
dewier104013463dewier_
diary95016973d__iary
dilly94923783d__illy
doily95321033d_oil_y
dopily123510463dopil_y
dozily19329103dozil_y
drily95816523d_ril_y
edgily1136063edgil_y
eerily92913563eeril_y
every115215453_ev_ery
evil75318073_evil__
eviler94811893_eviler
evils84114263_evil_s
heavily1665903heavil_y
jewelry2041993jewelry
kevil12399863kevil__
kevils13358333kevil_s
levelly1335853levelly
levier94013873levier_
leviers103510343leviers
levity1277903levi_ty
nervily1336863nervil_y
retiary1038333retiary
revery124014213rev_ery
revile94921613revil_e
reviled114417923reviled
reviler104314973reviler
revilers114011693revilers
reviles104421353reviles
revisory14306013revisory
rivalry1354033rivalry
semidry1345203semidry
sexily1638853sexil_y
verily122616053veril_y
wavily15219483wavil_y
weevilly1782623weevilly
weevily1694643weevil_y

Search took 8 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.420425454.8
2DLD Change Limit1340271216.90619407.3
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.37224239.1
 
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.