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

198 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
deranger103735(None) 
derange939811derange_
deranged1137691deranged
derangers1136701derangers
deranges1039971deranges
deringer1038141deringer
arranger936872arranger
danger83722822d__anger
decanter112510792decanter
defanged1435432defanged
defragger1542602defragger
demander12238722demander
deringers1137182deringers
dernier83011942der_nier
derringer1144592derringer
dragger10309172d_ragger
granger93514212_granger
ranger73925522__ranger
stranger94715102stranger
anger66225873___anger
arrange838683arrange_
arranged1036933arranged
arrangers1045813arrangers
arranges939413arranges
banger94423633__banger
befinger1434643befinger
beringed1298173beringed
bragger113810043_bragger
brander103915823_brander
branner94212373_branner
bringer104213353_bringer
changer134215543_changer
clanger104113493_clanger
cranker133612783_cranker
cringer103514243_cringer
dagger95017303d__agger
damager1157973dama_ger
dancer94817613d__ancer
dander811222993d__ander
danged94819483d__anged
dangers94818213d__angers
dangler96912813d__angler
danker114319663d__anker
darner74017303dar_n_er
deader84220473de_a_der
deafer104114813de_a_fer
dealer74122143de_a_ler
deaned84620453de_an_ed
deanery1137613de_an_ery
dearer74822803de_a_rer
debagged1433723debagged
debarker15155503debarker
debaser103510413deba_ser
debater104114693deba_ter
deboner103110483debon_er
debugger1343123debugger
debunker1543093debunker
decane93818873decan_e_
decanes103118913decan_es
decanted122310493decanted
decanters12229223decanters
decayer13339353deca_yer
decenter112412163decenter
defacer132810363defa_cer
defamer132710323defa_mer
defang1137753defang__
defangs1235363defang_s
defender1337293defender
definer114413773defin_er
defogger1443533defogger
defragged1643043defragged
defraggers1642013defraggers
defrauder1442533defrauder
defrayer1534933defra_yer
degage92711383dega_ge_
degasser10325813degasser
degender1136893degender
degrader11247913degra_der
delayer113010533dela_yer
demanded13348513demanded
demanders13247573demanders
demerger12127373demerger
denier74420693de__nier
denser74115193de__nser
depraver1435413depra_ver
deraign936573deraig_n
deraigned1244093deraigned
deraigns1034883deraigns
derailed102410403derailed
deranging1238063deranging
derate74531233dera_te_
derated93623503dera_ted
derates84028893dera_tes
deratted1048403deratted
derider93214973der_ider
deriver114213913der_iver
derringers1243843derringers
desalter938363desalter
desanded11227453desanded
descanter1246443descanter
designer1036543designer
detacher1437543detacher
detailer9268673detailer
detainer92910793detainer
deterger10147593deterger
dewater112912423dewa_ter
dinger85323673d__inger
dowager1245803dowa_ger
drabber12438593d_rabber
drafter11449423d_rafter
dragee84415603d_ra_gee
dragged11379563d_ragged
draggers11357393d_raggers
draggier11135773d_raggier
dragnet91211433d_ragnet
drainer83012843d_rainer
draper94315693d_ra_per
drawer104711363d_ra_wer
drawler11338593d_rawler
dreamer104110843drea_mer
dreamier11287293dreamier
drearier9297923drearier
dredger10347453d_redger
drinker12349483d_rinker
droner74717673d_ron_er
drudger10328323d_rudger
drunker12326633d_runker
durance1059113durance_
durances1158683durances
eager65526973_e_a_ger
earner63617223_earn_er
endanger1045853endanger
eraser64216333_era_ser
estranger10447843estranger
evangel1134303_evangel
fernier103110823fer_nier
flanger113412623_flanger
forager114412563fora_ger
franker143510183_franker
ganger83721463__ganger
germander1345363germander
grander93315873_grander
grange83716203_grange_
grangers103011973_grangers
granges93516523_granges
granter84117133_granter
grunger9389783_grunger
hanger104023253__hanger
haranguer1342863haranguer
leaner64022193le_an_er
learner7319383learn_er
levanter1145303levanter
manger94325003__manger
meager94515203me_a_ger
meander1049973me_ander
meaner84617843me_an_er
melange1038363melange_
melanges1138613melanges
merganser1242843merganser
merger95016483mer__ger
orange74016323_orange_
orangery12305543_orangery
oranges84215333_oranges
orangey11388833_orangey
orangier947713_orangier
prancer113613383_prancer
pranged114512553_pranged
range64728413__range_
ranged84824313__ranged
rangers83621043__rangers
ranges73826923__ranges
rangier83714353__rangier
ranker105021903__ranker
ranter63826823__ranter
recanter101913153recanter
rehanged1357833rehanged
revenger1237303revenger
ringer74526063__ringer
sanger74524563__sanger
serener73415763seren_er
serger73819743ser__ger
springer113311753springer
strander97112063strander
strange85416343strange_
strangers104112163strangers
stranges94516763stranges
strangler10369473strangler
stringer93812943stringer
stronger9349693stronger
teenager9115293teenager
twanger11327433_twanger
verger104315703ver__ger
vernier102711273ver_nier
weaner93816773we_an_er
wrangler1245473_wrangler
wringer113612453_wringer
wronger11288823_wronger
yearner10336873yearn_er

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621987.87618557.9
3Display Results1981980.0802475.0
 (SQL Overall)1786911988.37621333.7
 
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.