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

250 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
deranges103997(None) 
derange939811derange_
deranged1137691deranged
deranger1037351deranger
derangers1136701derangers
arranges939412arranges
decanes103118912decan_es
defanged1435432defanged
defangs1235362defang_s
deraigns1034882deraigns
derates84028892dera_tes
deringer1038142deringer
deringers1137182deringers
durances1158682durances
granges93516522_granges
melanges1138612melanges
oranges84215332_oranges
ranges73826922__ranges
stranges94516762stranges
aerates74627493aera_tes
arrange838683arrange_
arranged1036933arranged
arranger936873arranger
arrangers1045813arrangers
averages1249183avera_ges
beanies93821093be_anies
befringes15104453befringes
berakes134815773bera_kes
berates94126873bera_tes
beringed1298173beringed
borages103917163bora_ges
boranes93720403boran_es
carnages11312213carnages
cerastes101111093cerastes
cerates95428253cera_tes
cetanes9315133cetan_es
changes134517583_changes
cranes84330753_cran_es
cringes103215503_cringes
damages11511273dama_ges
dances95120653d__ances
danged94819483d__anged
danger83722823d__anger
dangers94818213d__angers
dangles93618423d__angles
dangs75623203d__ang_s
darings93713653daring_s
deaned84620453de_an_ed
deans66131393de_an__s
dearies83526273de_aries
dearness939973dearness
deashes113313903de_ashes
deaves105319533de_a_ves
debacles1335723debacles
debagged1433723debagged
debags104211063deba_g_s
debases103814133deba_ses
debates103718533deba_tes
debones103315113debon_es
decades113615513deca_des
decane93818873decan_e_
decanted122310493decanted
decanter112510793decanter
decanters12229223decanters
decants103514443decan_ts
decares102818533deca_res
decongest1345633decongest
dedans85915073dedan__s
defaces133213403defa_ces
defames132812253defa_mes
defang1137753defang__
defences1439633defences
defenses1237913defenses
defiances1557033defiances
defines114118683defin_es
defragged1643043defragged
defragger1542603defragger
defraggers1642013defraggers
defrags1236193defra_g_s
degage92711383dega_ge_
degames113312623dega_mes
degases93413103dega_ses
degasses10278363degasses
degrades11269923degra_des
dekares122710873deka_res
delaines9312963delaines
delates83526283dela_tes
deluges9169263de_luges
demanded13348513demanded
demander12238723demander
demanders13247573demanders
demands114311413deman_ds
demerges12129503demerges
denes65639723de__n_es
dengues938183de__ngues
denies74729643de__nies
deplanes11311213deplan_es
depones103717093depon_es
depraves1436873depra_ves
deraign936573deraig_n
deraigned1244093deraigned
derailed102410403derailed
derails84216393dera_ils
deranging1238063deranging
derate74531233dera_te_
derated93623503dera_ted
derats74625063dera__ts
deratted1048403deratted
derays105514253dera__ys
derbies103016053der_bies
derides93420853der_ides
derives114017813der_ives
dermises112512023dermises
dernier83011943der_nier
derries83124623der_ries
derringer1144593derringer
derringers1243843derringers
derrises93012783derrises
desanded11227453desanded
desands94810163desan_ds
detaches1439653detaches
detainees10267153detainees
detentes92712873detentes
deterges101510093deterges
detinues9569823detinues
devalues1235853devalues
deviances1566493deviances
dewans105215143dewan__s
dewaxes18297843dewa_xes
dinges83825423d__inges
dirges84915103dir__ges
dosages92310803dosa_ges
dotages92311793dota_ges
dragee84415603d_ra_gee
dragees9359483d_ragees
dragged11379563d_ragged
dragger10309173d_ragger
draggers11357393d_raggers
draggles1145963d_raggles
dragnet91211433d_ragnet
dragnets10136563d_ragnets
drags75521113d_ra_g_s
drainages1145503d_rainages
drakes114715863d_ra_kes
drapes95419653d_ra_pes
drawees11378363d_rawees
drayages1344503d_rayages
drearies92313413drearies
dredges10379353d_redges
drones75023433d_ron_es
drongos935493d_rongos
drudges10308873d_rudges
dunnages10154933dunnages
durables11237013durables
durance1059113durance_
enrages83114853enra_ges
erases64425403_era_ses
eringoes937433_eringoes
eringos836913_eringos
ernes55224813_er_n_es
eryngoes1242943_eryngoes
eryngos1142733_eryngos
estranges10359983estranges
evangel1134303_evangel
evangels1243733_evangels
flanges113413273_flanges
forages114217283fora_ges
fringes113514103_fringes
furanes103214863furan_es
garages9314113gara_ges
grange83716203_grange_
granger93514213_granger
grangers103011973_grangers
grunges93310403_grunges
harangues1344633harangues
henges104516463he__nges
herbages1437093herbages
hexanes17319463hexan_es
iterances1148903iterances
kernes104717533ker_n_es
larynges1244503larynges
manges94628943__manges
meanies93620743me_anies
melange1038363melange_
menages103615393mena_ges
meninges1137433meninges
merengues1243373merengues
merges94122493mer__ges
meringues1244383meringues
metages102714973meta_ges
midranges1344653midranges
mirages102213533mira_ges
orange74016323_orange_
orangey11388833_orangey
orangs74116033_orang_s
ourangs8318503ourang_s
outranges102510013outranges
overages12513833overa_ges
parangs104314373parang_s
peages94321853pe_a_ges
peerages1189893peera_ges
pelages10714613pela_ges
penances12312443penances
penangs10268373penang_s
peonages1138473peonages
prances113618773_prances
pranged114512553_pranged
prangs94816233_prang_s
rages64539443__ra_ges
rances84625443__rances
ranees64623963__ranees
range64728413__range_
ranged84824313__ranged
ranger73925523__ranger
rangers83621043__rangers
rearranges1145113rearranges
recanes93222263recan_es
rechanges1568183rechanges
regauges1046093regauges
rehanged1357833rehanged
rehangs1137563rehang_s
rehinges1248403rehinges
reraises8415643reraises
revenges1238983revenges
seances93015343se_ances
serapes95218103sera_pes
serenes73222903seren_es
serfages1238233serfages
serges74225973ser__ges
serines74229543serin_es
seringas9339003seringas
sewages1139753sewa_ges
sprangs104610053sprang_s
springes114014033springes
strange85416343strange_
stranger94715103stranger
strangers104112163strangers
strangest103210843strangest
strangles103011553strangles
syringes122810213syringes
ternes65422903ter_n_es
terranes82514433terran_es
tetanies8513553tetanies
trances93919643_trances
underages11811083undera_ges
venges104015153ve__nges
verandas1246233verandas
verges104320183ver__ges
wrangles1237463_wrangles
wrangs104611913_wrang_s

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.440406115.9
2DLD Change Limit1461622508.37617450.1
3Display Results2502500.1062358.5
 (SQL Overall)1786912508.92220028.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.