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

149 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
dirdum103603(None) 
dirdums1134381dirdums
diadem1037582diadem
dictum1136862dictum
dinkum1335892dinkum
diram84419472dir_am
dirham12378272dirham
dorsum947622dorsum
drum76521592d_r_um
dumdum1244522dumdum
durum8513202dur_um
airbus848343airbus
arum66129033_ar_um
atrium8411823atrium
aurum7614963aur_um
barium10313513barium
bird76128323bird__
birded104414303birded
birder94915493birder
birdie94013783birdie
birds85421333bird_s
cerium10313763cerium
cilium104311373cilium
circus104310593circus
cirque1735853cirque
cirrus8349173cirrus
corium10315723corium
crinum1039333crinum
cundum1136513cundum
curium10312503curium
dadgum1134583dadgum
datum8310633d_atum
degum94711903d_egum
delirium1146583delirium
derm76031893der__m
diadems1135393diadems
diatom939453diatom
dibbuk1543503dibbuk
dictums1235553dictums
did56850523di_d__
diddle94915213diddle
diddly12389573diddly
didie74120563di_die
dido66528203di_d_o
didos76820813di_dos
didst74619613di_dst
didy99121513di_d_y
died66137853died__
dikdik1152613dikdik
dildo71911773dild_o
dildoe8198673dildoe
dildos8179303dildos
dim68146493di___m
dimout9414243dimout
dindle84417223dindle
dingus83611843dingus
dinkums1433673dinkums
diode74716113diod_e
diodes83915783diodes
dirams94413703dirams
dire56644143dir__e
direct93817333direct
direful1156613direful
direly10311563direly
direr64927073dir_er
direst75024243direst
dirge75117073dir_ge
dirges84915103dirges
dirhams13376313dirhams
dirk96326833dir__k
dirked124912273dirked
dirks105619523dir_ks
dirl57430023dir__l
dirled84514903dirled
dirls64720503dir_ls
dirndl834253dirndl
dirndls933893dirndls
dirt55550383dir__t
dirts66824463dir_ts
dirty95617803dir_ty
disarm9310473disarm
disbud10165713disbud
discus94512113discus
diseur738843diseur
dogdom1186363dogdom
dorbug1034953dorbug
dorm76834633dor__m
doum76226673d__oum
dram75832003d_r_am
dream85120393d_ream
drouk1039433d_rouk
drub75920133d_r_ub
drug65718133d_r_ug
drums85415873d_r_ums
dumdums1343043dumdums
durums948153dur_ums
eardrum10135423eardrum
ferrum1147453ferrum
filum105015433fi_lum
firm96026453fir__m
forum108318763for_um
gird65424993gird__
girded93712493girded
girder84312063girder
girdle82110463girdle
girds74816993gird_s
grum75625083_gr_um
heirdom1344493heirdom
hilum105514603hi_lum
idem76121063_i_dem
ileum74512823_ileum
ilium74614183_ilium
imaum9139643_imaum
indium939503_indium
indue63516673_indue
iridium1046303_iridium
jorum145513743jor_um
larum74317973lar_um
linum7313823li_num
milium104712683milium
minium106014423minium
nidus65913573ni_dus
odium83413033odi__um
oidium959813oidium
perdu84216273perdu_
perdue93912633perdue
perdus93711273perdus
pileum10399513pileum
rum56644643__r_um
scrum95418203scr_um
sedum84115573_sedum
serum75223473ser_um
siddur834573siddur
siglum936563siglum
sirdar7269103sirdar
sirup74014913sir_up
strum75619453str_um
tergum937933tergum
thrum104713633thr_um
triduum1043413triduum
virtu85314093virtu_
virtue9358673virtue
virtus94310143virtus
virus85316843vir_us
windup1235383windup
wisdom1235983wisdom
yird87018983yird__
yirds96612513yird_s
ziram163912893zir_am

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127161494.70323966.8
3Display Results1491490.0463239.1
 (SQL Overall)1786911495.14234751.3
 
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.