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

111 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
dirdums113438(None) 
dirdum1036031dirdum_
diadems1135392diadems
dictums1235552dictums
dinkums1433672dinkums
dirams94413702dir_ams
dirhams13376312dirhams
drums85415872d_r_ums
dumdums1343042dumdums
durums948152dur_ums
airbus848343airbu_s
arums75517833_ar_ums
atriums939043atriums
aurums849383aur_ums
bariums1139143bariums
birders103913263birders
birdies104016213birdies
birds85421333bird__s
ceriums1139473ceriums
circus104310593circu_s
cirques1836463cirques
cirrus8349173cirru_s
crinums1135863crinums
cundums1235183cundums
curiums1138503curiums
datums936353d_atums
degums10438623d_egums
deliriums1244473deliriums
derms85022893der__ms
diadem1037583diadem_
diatoms1039073diatoms
dibbuks1643163dibbuks
dictum1136863dictum_
diddles103915073diddles
didies84621833di_dies
didoes85716963di_does
didos76820813di_d_os
dikdiks1242563dikdiks
dildoes9229243dildoes
dildos8179303dild_os
dimouts1037893dimouts
dims75435023di___ms
dindles93817243dindles
dingus83611843dingu_s
dinkum1335893dinkum_
diodes83915783diod_es
diram84419473dir_am_
directs102710263directs
dirges84915103dir_ges
dirham12378273dirham_
dirks105619523dir__ks
dirls64720503dir__ls
dirndls933893dirndls
dirties83119383dirties
dirts66824463dir__ts
disarms1039043disarms
disbuds11125243disbuds
discus94512113discu_s
discuss10357953discuss
diseurs839403diseurs
dogdoms1295423dogdoms
doldrums1243053doldrums
dorbugs1132983dorbugs
dorms85723843dor__ms
dorsum947623dorsum_
doums85417643d__oums
drams86025833d_r_ams
dreams94513983d_reams
drouks1137123d_rouks
drubs85913833d_r_ubs
drugs75214653d_r_ugs
drum76521593d_r_um_
dumdum1244523dumdum_
durum8513203dur_um_
eardrums11524483eardrums
ferrums1265983ferrums
firms105217423fir__ms
forums114611843for_ums
girders9379943girders
girdles92210003girdles
girds74816993gird__s
heirdoms1444353heirdoms
imaums10106303_imaums
indiums1037143_indiums
indues73515263_indues
iridiums1144523_iridiums
jorums15408093jor_ums
larums83610533lar_ums
linums838283li_nums
miniums113910223miniums
nidus65913573ni_du_s
odiums9337943odi__ums
perdues103511333perdues
perdus93711273perdu_s
rums64833473__r_ums
scrums104614253scr_ums
sedums93910483_sedums
serums83916303ser_ums
siddurs934173siddurs
sirdars8228213sirdars
sirups83710533sir_ups
strums84716453str_ums
thrums11429123thr_ums
triduums1142613triduums
virtues10338023virtues
virtus94310143virtu_s
virus85316843vir_u_s
windups1334783windups
wisdoms1335453wisdoms
yirds96612513yird__s
zirams17438643zir_ams

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271117.56317721.4
3Display Results1111110.0462413.0
 (SQL Overall)1786911118.03222247.4
 
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.