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

248 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
deranged113769(None) 
defanged1435431defanged
derange939811derange_
deranger1037351deranger
deranges1039971deranges
arranged1036932arranged
beringed1298172beringed
danged94819492d__anged
deaned84620452de_an_ed
debagged1433722debagged
decanted122310492decanted
defragged1643042defragged
demanded13348512demanded
deraigned1244092deraigned
derailed102410402derailed
derangers1136702derangers
derated93623502dera_ted
deratted1048402deratted
deringer1038142deringer
desanded11227452desanded
dragged11379562d_ragged
pranged114512552_pranged
ranged84824322__ranged
rehanged1357832rehanged
aerated85322383aera_ted
arrange838683arrange_
arranger936883arranger
arranges939413arranges
averaged1356223avera_ged
banged104923733__banged
beaned95621473be_an_ed
befringed16123863befringed
belonged1235313belonged
beraked144312433bera_ked
berated104422133bera_ted
berouged1235343berouged
bewinged1584473bewinged
bragged12449843_bragged
branded114414103_branded
branned104311693_branned
carangid1246423carangid
cerated103922473cera_ted
changed144214143_changed
clanged114212653_clanged
cragged12479883_cragged
craned96121653_cran_ed
cranked143812843_cranked
cringed113312403_cringed
damaged1257463dama_ged
danced105315253d__anced
danger83722833d__anger
dangled104013153d__angled
darned85018483dar_n_ed
deaired9411533de_aired
deashed123411303de_ashed
deaved114916553de_a_ved
debarked16175833debarked
debarred12165643debarred
debased113310583deba_sed
debated113916083deba_ted
deboned113411633debon_ed
debugged1433223debugged
debunked1633193debunked
decamped1634973decamped
decane93818873decan_e_
decanes103118913decan_es
decanter112510793decanter
decayed14309333deca_yed
defaced142910973defa_ced
defamed14309833defa_med
defang1137753defang__
defangs1235363defang_s
defatted1335673defatted
defenced1537203defenced
defended1437223defended
defensed1336223defensed
defined123813823defin_ed
defogged1533783defogged
defragger1542603defragger
defrauded1542823defrauded
defrayed1635403defra_yed
defunded1435163defunded
degage92711383dega_ge_
degassed11275963degassed
degraded12288323degra_ded
deigned1037503deign_ed
delated93722873dela_ted
delayed123310763dela_yed
deluged10167413de_luged
demagoged15103643demagoged
demand104314253deman__d
demander12238723demander
demarked16187223demarked
demasted1238763demasted
demeaned1237283demean_ed
demented12311273demented
demerged13157603demerged
denied84318633de__nied
denned84215633de__nned
dented84120513de__nted
depainted1375843depainted
departed1238823departed
depended1337983depended
deplaned1238663deplan_ed
deponed113712873depon_ed
depraved1535543depra_ved
deraign936573deraig_n
deraigns1034883deraigns
deranging1238063deranging
derate74531233dera_te_
derates84028893dera_tes
derided102914253der_ided
deringers1137183deringers
derived123912763der_ived
dernier83011943der_nier
derringer1144593derringer
desalted1038313desalted
desand84812633desan__d
descanted1336673descanted
designed1136943designed
detached1537733detached
detailed10319873detailed
detained103111643detained
deterged11127923deterged
detracted1357793detracted
detrained1158913detrained
devalued1335013devalued
dewaxed19316053dewa_xed
dezinced2183903dezinced
dinged95221783d__inged
doghanged1642343doghanged
drabbed13428723d_rabbed
drafted12439033d_rafted
dragee84415603d_ra_gee
dragger10309173d_ragger
draggled1254673d_raggled
dragnet91211433d_ragnet
drained93713253d_rained
drammed13378073d_rammed
draped105314363d_ra_ped
dratted9358593d_ratted
drawled12368343d_rawled
drayed115911393d_ra_yed
dreaded103612023drea_ded
dreamed114310633drea_med
dredged11346893d_redged
droned84616863d_ron_ed
drudged11277613d_rudged
drugged11367183d_rugged
dunged95414693d__unged
durance1059113durance_
durances1158683durances
durned84113173dur_n_ed
earned74818333_earn_ed
enraged93511783enra_ged
erased74816763_era_sed
estranged11387663estranged
evangel1134303_evangel
fanged114318233__fanged
flanged123810843_flanged
foraged124812283fora_ged
fragged134010163_fragged
franked153610053_franked
fringed123611523_fringed
ganged94619203__ganged
garaged1039253gara_ged
grange83716203_grange_
granger93514213_granger
granges93516523_granges
granted94715103_granted
hanged114222403__hanged
harangued1442783harangued
heralded1335443heralded
herbaged1554533herbaged
jeaned143813463je_an_ed
kerned114112933ker_n_ed
leaned73422543le_an_ed
learned8329303learn_ed
levanted1245323levanted
melange1038363melange_
melanges1138613melanges
merged104214953mer__ged
orange74016323_orange_
oranges84215333_oranges
orangey11388833_orangey
outranged11239043outranged
overaged13511673overa_ged
panged104722343__panged
penanced1338163penanced
pranced123714043_pranced
pranked143712093_pranked
preaged11612333prea_ged
pronged113912393_pronged
raged74829453__ra_ged
ragged94620263__ragged
range64728423__range_
ranger73925533__ranger
ranges73826933__ranges
ranked114620743__ranked
ranted74324703__ranted
rearranged1244103rearranged
recaned102817203recan_ed
recanted112513513recanted
rechanged1646853rechanged
regauged1135143regauged
regranted1137703regranted
rehinged1336853rehinged
relanded102410463relanded
remanded123011323remanded
remanned11319353remanned
reracked15169123reracked
reraised9312363reraised
rerented92516163rerented
rerigged1136243rerigged
retagged1136063retagged
revenged1337553revenged
ringed84623843__ringed
scragged1335823scragged
serged84118773ser__ged
slanged94112853_slanged
springed123911323springed
stanged94113853_stanged
stranded102710813stranded
strange85416343strange_
stranger94715103stranger
stranges94516763stranges
strangled11268983strangled
stringed102911873stringed
syringed13377583syringed
tanged84622513__tanged
teenaged10105133teenaged
tenanted937043tenanted
thronged13405333thronged
tranced104414173_tranced
twanged12387283_twanged
underaged121011243undera_ged
unhanged13258833unhanged
unranked1338563unranked
venged114011993ve__nged
verandaed1443143verandaed
verged114815163ver__ged
weaned103816153we_an_ed
whanged15447613_whanged
wrangled1335593_wrangled
wringed123710193_wringed
wronged12397673_wronged
yeaned103813903ye_an_ed
yearned11327373yearn_ed

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.436409841.7
2DLD Change Limit1461622487.78018786.9
3Display Results2482480.0962583.3
 (SQL Overall)1786912488.31221498.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.