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

281 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
dildoe819867(None) 
dildo71911771dildo_
dildoes9229241dildoes
dildos8179301dildos
diddle94915212diddle
didie74120562di_die
dido66528202di_do_
didoes85716962di_does
didos76820812di_dos
dilate73220692dilate
dilute72911802dilute
dindle84417222dindle
diode74716112diod_e
diploe9810152diploe
tilde65017342tild_e
aide56045003ai_d_e
aldol61212333_aldol
aldose7311093_aldose
aloe45540193_al_oe
bide76041503bi_d_e
bilbo95513613bilbo_
bilboa10367843bilboa
bilboes114410243bilboes
bilbos105011203bilbos
bile66147183bil__e
bilge87618913bil_ge
billie85019173billie
billon83713833billon
billow114111223billow
bindle94516263bindle
birdie94013783birdie
childe124711213child_e
cilice103213353cilice
daddle94214283daddle
dado67126333d_ado_
dadoed9449903d_adoed
dadoes85616533d_adoes
dados75522433d_ados
dale55643983dal__e
dalton7311273dalton
dandle84218093dandle
dawdle11399503dawdle
decode104414743decode
delate73827753delate
dele56843083del__e
delete73620703delete
delime9314043delime
delude81910673delude
deluge8189403deluge
deluxe14197303deluxe
delve96018263del_ve
demode104013463demode
diadem1037583diadem
dialog837973dialog
dialyse1135463dialyse
dialyze2044433dialyze
diatom939453diatom
diazo15310033diazo_
diazole1736793diazole
dibble114013843dibble
dice75841893di__ce
dickie133913113dickie
dicot85429093di_cot
did56850523di_d__
diddled114212053diddled
diddler103511513diddler
diddles103915073diddles
diddley13388103diddley
diddly12389573diddly
didies84621833di_dies
didst74619613di_dst
didy99121513di_d_y
die46759653di___e
died66137853died__
diene65720133di_ene
diglot83014333diglot
dikdik1152613dikdik
dike95935763di__ke
dilated93115823dilated
dilater83515653dilater
dilates83220663dilates
dilator82712783dilator
dill55239973dil__l
dilled84122223dilled
dillies84122163dillies
dills65530973dil_ls
dilly94923783dil_ly
diluted9248933diluted
diluter8319663diluter
dilutes82911973dilutes
dilutor8256013dilutor
dime76237643di__me
dimple113512793dimple
dindled104412723dindled
dindles93817243dindles
dine55555333di__ne
dinge75627303di_nge
dingle84317073dingle
dingo74720793dingo_
dingoes94114833dingoes
dino56036753di_no_
dinos65428063di_nos
diobol936883diobol
diodes83915783diodes
diol57329133di__ol
diploes101111493diploes
dipody1336363dipody
dipole91112853dipole
dipso85111553dipso_
dipsos95310053dipsos
dirdum1036033dirdum
dire56644143di__re
dirge75117073di_rge
disco85616073disco_
discoed11312483discoed
discos94915213discos
dislike122913453dislike
dislodge1145173dislodge
disme85716243di_sme
displode1247643displode
dispose10312763dispose
disrobe1038993disrobe
distome10313233distome
disuse74012843disuse
disyoke1546233disyoke
dite55547553di__te
ditto65315603ditto_
dittoed936733dittoed
dittos74111973dittos
diuron738573diuron
dive85634773di__ve
divide113410893divide
divine103514463divine
divot95723073di_vot
dodge86618133d_odge
dodo66024913d_odo_
dodoes85716103d_odoes
dodos75819393d_odos
doe47361953___doe
dogdom1186363dogdom
dolce85816683dol_ce
dole56550003dol__e
dollop9259363dollop
dolor67617963dol_or
doodle83212853doodle
doodoo8108893doodoo
dredge9308563dredge
drudge9317903drudge
duddie9348863duddie
dude65629663d_ud_e
dulse65415043dul_se
dwindle12415883dwindle
dynode1135023dynode
edile64819493edil__e
eide55832243ei_d_e
eidos65817753ei_dos
elide64922643elid_e
evildoer1241933evildoer
felloe93513923felloe
fiddle113613383fiddle
fidge104516063fi_dge
fido87726403fi_do_
fidos95819053fi_dos
file75446643fil__e
fille84327403fil_le
fillo84319783fillo_
fillos94415083fillos
filmdom1562943filmdom
filo76034283fil_o_
filos86125383fil_os
filose96112503filose
floe76129773_fl_oe
gild65526513gild__
gilded94413223gilded
gilder84415533gilder
gilds75417523gild_s
gillie74816943gillie
girdle82110463girdle
glide74521593glid_e
hide85134643hi_d_e
hillo84721653hillo_
hilloa94713033hilloa
hilloed113211293hilloed
hilloes103815963hilloes
hillos94618893hillos
idle55423763_i_dle
idol56818633_i_dol
indie63721473_indie
indol63714873_indol
indole74516053_indole
indow95011663_indow
indue63516673_indue
kiddie12359393kiddie
kiddo11398953kiddo_
kiddoes13387063kiddoes
kiddos12416863kiddos
killdee1266223killdee
killie104114893killie
kilo86028673kil_o_
kilos95021473kil_os
kiltie103210963kiltie
kindle114414233kindle
lido56028163li_do_
lidos65219883li_dos
lilo46731563lil_o_
lilos55821873lil_os
lode56240113__lode
middle103414983middle
midge95016553mi_dge
milage93414123milage
mild75330853mild__
milded104416153milded
milden94113153milden
milder93818453milder
mildew12319043mildew
mildly12318243mildly
milds86422053mild_s
mile66352573mil__e
mille75029133mil_le
milo65536103mil_o_
milos75428013mil_os
misdo85413183misdo_
misdoer1048633misdoer
misdoes10312493misdoes
misdone10310863misdone
nide55535793ni_d_e
oilhole1046263oilhole
oldie6415473_oldie
piddle103514913piddle
pile65649693pil__e
pillow113110573pillow
pilose84514243pilose
pilot77435063pil_ot
pilule8411123pilule
riddle83915713riddle
ride55945133ri_d_e
ridge75018673ri_dge
rile45650533ril__e
rille55728733ril_le
seldom939413seldom
side55444493si_d_e
sidhe95315103si_dhe
sidle65124033si_dle
silage72715303silage
silane62718053silane
sild55030583sild__
silds65520523sild_s
silkie103313403silkie
silo46037913sil_o_
siloed74615303sil_oed
silos56029433sil_os
silvae92811093silvae
slide64725413slid_e
sloe45534953_sl_oe
soldo67116563soldo_
tide55237383ti_d_e
tildes74513963tildes
tile45451443til__e
tiptoe838283tiptoe
vide85432763vi_d_e
video96014953vi_deo
vile76139803vil__e
villae95615383villae
villose1038053villose
weldor10317653weldor
widdie113410733widdie
widdle113814843widdle
wide85235413wi_d_e
widow1278933wi_dow
wilco1039443wilco_
wild85126513wild__
wilded113714503wilded
wilder103616473wilder
wildly13328123wildly
wilds94818203wild_s
wile75944373wil__e
willie94116453willie
willow12369693willow
windle104617953windle
window1347363window
wisdom1235983wisdom

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.373479064.3
2DLD Change Limit1127162815.40620850.2
3Display Results2812810.0803512.5
 (SQL Overall)1786912815.85930498.5
 
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.