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

202 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
deranging123806(None) 
defanging1535331defanging
arranging1156302arranging
danging103716092d__anging
deaning94020472de_an_ing
debagging1533592debagging
decanting132510632decanting
defragging1742822defragging
demanding14237922demanding
deraigning1344102deraigning
derailing112011312derailing
derating103222282dera_ting
deratting1139512deratting
desanding12207652desanding
dragging12308102d_ragging
pranging123012722_pranging
ranging94120262__ranging
rehanging1437562rehanging
aerating92821003aera_ting
averaging1446503avera_ging
banging114019863__banging
beaning103820683be_an_ing
befringing1744063befringing
belonging1335913belonging
beraking153612973bera_king
berating113220763bera_ting
bragging13359333_bragging
branding122513683_branding
branning112911093_branning
bringing123011273_bringing
changing153211513_changing
clanging124012123_clanging
craning103620303_cran_ing
cranking154613073_cranking
cringing123311383_cringing
damaging1337393dama_ging
dancing113611563d__ancing
dangling112611233d__angling
darning93817333dar_n_ing
deairing10311893de_airing
dealing94323233de_a_ling
deashing134210953de_ashing
deaving123814753de_a_ving
debarking1735383debarking
debarring1335723debarring
debasing12238063deba_sing
debating123213733deba_ting
deboning12109153debon_ing
debugging1542993debugging
debunking1733353debunking
decamping1734943decamping
decaying15239453deca_ying
defacing15238683defa_cing
defaming15238463defa_ming
defatting1436103defatting
defencing16226693defencing
defending15298353defending
defensing14217003defensing
defining133711803defin_ing
defogging1653863defogging
defrauding1642923defrauding
defraying1735853defra_ying
defunding15216123defunding
degassing1234823degassing
degrading13137373degra_ding
deigning1137753deign_ing
delating103119603dela_ting
delaying133210973dela_ying
deluging1137123de_luging
demagoging1643193demagoging
demarking1736773demarking
demasting1338453demasting
demeaning1337243demean_ing
dementing13311043dementing
demerging1436643demerging
denning93515173de__nning
denting94422183de__nting
denying123711293de__nying
depainting14156153depainting
departing1349513departing
depending14208783depending
deplaning1338053deplan_ing
deponing121211213depon_ing
depraving1635973depra_ving
deraign936573deraig_n_
deraigns1034883deraig_ns
derange939813derang__e
deranged1137693derang_ed
deranger1037353derang_er
derangers1136703derangers
deranges1039973derang_es
deriding112512933der_iding
deriving132510743der_iving
desalting1138843desalting
descanting1446923descanting
designing1236623designing
detaching1637263detaching
detailing112510413detailing
detaining112510473detaining
deterging1237853deterging
detracting1438713detracting
detraining1267673detraining
devaluing1434833devaluing
dewaxing20215293dewa_xing
dezincing2244183dezincing
dinging103618613d__inging
drabbing14286803d_rabbing
drafting13339413d_rafting
draggling1354613d_raggling
draining103312673d_raining
dramming14347573d_ramming
draping114213353d_ra_ping
dratting10389663d_ratting
drawing123812053d_ra_wing
drawling13318673d_rawling
draying123813843d_ra_ying
dreading113712803drea_ding
dreaming124011063drea_ming
dredging12236423d_redging
drinking14308913d_rinking
droning93013723d_ron_ing
drudging12256233d_rudging
drugging12326443d_rugging
dunging103012623d__unging
durning93511733dur_n_ing
eanling81416673_e_anling
earning83418213_earn_ing
enraging1049573enra_ging
erasing8317963_era_sing
estranging1246023estranging
flanging132710583_flanging
foraging1358063fora_ging
fragging14329423_fragging
franking164310863_franking
fringing133010903_fringing
ganging103216193__ganging
garaging1139043gara_ging
granting103514523_granting
hanging123518703__hanging
haranguing1543113haranguing
heralding1435773heralding
kerning124010893ker_n_ing
leaning83721203le_an_ing
learning978553learn_ing
levanting1345523levanting
meaning103918703me_an_ing
merging112711763mer__ging
outranging1238003outranging
overhanging1946323overhanging
panging113319113__panging
penancing1436343penancing
prancing132612163_prancing
pranking153813383_pranking
pronging123511843_pronging
ragging103516683__ragging
raging85126433__ra_ging
ranking124320883__ranking
ranting84025413__ranting
rearranging1343783rearranging
recaning111416693recan_ing
recanting122414823recanting
rechanging1746043rechanging
regauging1235543regauging
regranting1238323regranting
rehinging1437453rehinging
relanding112110923relanding
remanding132211143remanding
remanning12229033remanning
reracking1639313reracking
reraising10313773reraising
rerenting102617663rerenting
rerigging1236553rerigging
rerunning1036523rerunning
retagging1236033retagging
revenging1438083revenging
ringing93521283__ringing
scragging1435273scragging
serging93416673ser__ging
slanging103413433_slanging
springing1338743springing
stanging104013653_stanging
stranding1149653stranding
strangling1256403strangling
stringing1139753stringing
syringing1435883syringing
tanging93419533__tanging
tenanting1036213tenanting
thronging1435073thronging
trancing112812023_trancing
twanging13287063_twanging
unhanging1436363unhanging
venging123710943ve__nging
verging123812303ver__ging
weaning114117193we_an_ing
weanling12118643we_anling
whanging16267143_whanging
wrangling1456223_wrangling
wringing13279623_wringing
wronging13327393_wronging
yeaning113814633ye_an_ing
yeanling12107063ye_anling
yearning1296983yearn_ing

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412026.58022589.8
3Display Results2022020.0902244.4
 (SQL Overall)1786912027.09325192.6
 
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.