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

320 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
dildoes922924(None) 
didoes85716961di_does
dildoe8198671dildoe_
dildos8179301dildo_s
bilboes114410242bilboes
dadoes85616532d_adoes
diddles103915072diddles
didies84621832di_dies
didos76820812di_do_s
dilates83220662dilates
dildo71911772dildo__
dillies84122162dillies
dilutes82911972dilutes
dindles93817242dindles
dingoes94114832dingoes
diodes83915782diod_es
diploes101111492diploes
dodoes85716102d_odoes
hilloes103815962hilloes
kiddoes13387062kiddoes
misdoes10312492misdoes
tildes74513962tild_es
aides65336603ai_d_es
aldols7109713_aldols
aldose7311093_aldose
aldoses8311203_aldoses
aloes54933673_al_oes
baldies105317703baldies
biddies113514493biddies
bides85536773bi_d_es
bilbies114712343bilbies
bilboas11438733bilboas
bilbos105011203bilbo_s
biles75542143bil__es
bilges94915633bil_ges
bilious9310933bilious
billies93923503billies
billons93013363billons
billows123611293billows
bimboes13498733bimboes
bindles104016453bindles
bingoes104013983bingoes
birdies104016213birdies
childes134211273child_es
cilices113814023cilices
ciscoes113610733ciscoes
condoes104319203condoes
daddies103414943daddies
daddles104213803daddles
dadoed9449903d_adoed
dados75522433d_ado_s
dagoes85714603d_agoes
dailies84219263dail_ies
dales66439743dal__es
dalles74222063dal_les
dallies84023193dallies
daltons8310403daltons
dandies94121443dandies
dandles94218533dandles
dawdles12379163dawdles
decodes113914983decodes
delates83526283delates
deles65139253del__es
deletes83117933deletes
delimes10314193delimes
dellies83622213dellies
deludes91810643deludes
deluges9169263deluges
delves104917083del_ves
diadem1037583diad_em
diadems1135393diadems
dialogs938103dialogs
dialyses1236133dialyses
dialyzes2144503dialyzes
diaries83321953diaries
diatoms1039073diatoms
diazoles1836323diazoles
dibbles124013333dibbles
dices86434243di__ces
dickies143416343dickies
dicots94915793di_cots
diddle94915213diddle_
diddled114212053diddled
diddler103511513diddler
diddlers11359153diddlers
diddley13388103diddley
diddleys14334633diddleys
diddlies1137593diddlies
didie74120563di_die_
dido66528203di_do__
dienes75719903di_enes
dies55653523di___es
dieses75218693di_eses
diglots9299503diglots
dikdiks1242563dikdiks
dikes105831333di__kes
dilate73220693dilate_
dilated93115823dilated
dilater83515653dilater
dilaters92513063dilaters
dilators93213203dilators
dilled84122223dil_led
dills65530973dil__ls
dilute72911803dilute_
diluted9248933diluted
diluter8319663diluter
diluters9288113diluters
dilutors9306653dilutors
dimes85833043di__mes
dimples122813213dimples
dindle84417223dindle_
dindled104412723dindled
dines66449153di__nes
dinges83825423di_nges
dingies93618243dingies
dingles93818323dingles
dinkies123716033dinkies
dinos65428063di_no_s
diobols1036543diobols
diode74716113diod_e_
diols65521013di__ols
diploe9810153diploe_
diploses111110323diploses
dipodies1238413dipodies
dipoles101013753dipoles
dipsos95310053dipso_s
dirdums1134383dirdums
dirges84915103di_rges
dirties83119383dirties
discoed11312483discoed
discos94915213disco_s
dishes104622653di_shes
dislikes132810843dislikes
dislodges1245163dislodges
dismes95617673di_smes
displodes1347863displodes
dispose10312763dispose
disposes11313823disposes
disrobes1139743disrobes
disses75225963di_sses
distomes11314163distomes
disuses84015413disuses
disyokes1656503disyokes
ditches133215713ditches
dites66339153di__tes
ditties83116983ditties
dittoed936733dittoed
dittos74111973ditto_s
ditzes163212423di_tzes
diurons838823diurons
dives95832403di__ves
divides123211453divides
divines113514723divines
divots104712203di_vots
divvies1457663divvies
dizzies16279753dizzies
dodges96119083d_odges
dodos75819393d_odo_s
does56554473___does
dogdoms1295423dogdoms
doilies84017363doil_ies
doles67843753dol__es
dollies83620983dollies
dollops10287963dollops
dolors75115313dol_ors
doodies94218773doodies
doodles93614163doodles
doodoos9107623doodoos
dowdies123412733dowdies
dredges10379353dredges
drudges10308873drudges
dudes75424373d_ud_es
dulses73913653dul_ses
dwindles13366023dwindles
dynodes1235453dynodes
eddoes8199143_eddoes
ediles74016983edil__es
eidos65817753ei_do_s
elides74420693elid_es
evildoer1241933evildoer
evildoers1341773evildoers
felloes104114383felloes
ficoes114613463fi_coes
fiddles123212603fiddles
fidges114114393fi_dges
fidos95819053fi_do_s
filches153410723filches
files85441273fil__es
filles94224523fil_les
fillies103420253fillies
fillos94415083fillo_s
filmdoms1642503filmdoms
filos86125383fil_o_s
filose96112503fil_ose
floes85528143_fl_oes
fordoes11311963fordoes
giddies103713363giddies
gilded94413223gild_ed
gilder84415533gild_er
gilders94212463gilders
gilds75417523gild__s
gillies84120963gillies
ginzoes1735433ginzoes
girdles92210003girdles
glides84518863glid_es
halloes104021523halloes
haloes94623863hal_oes
helloes103717463helloes
hides95129423hi_d_es
hilloas104413553hilloas
hilloed113211293hilloed
hillos94618893hillo_s
holloes103818193holloes
hulloes104113923hulloes
ides57734233_i_d_es
idles66720123_i_dles
idols65514133_i_dols
ilexes134510253_ilexes
indies73822783_indies
indoles83716363_indoles
indols74714203_indols
indows104210793_indows
indues73515263_indues
iodous7311503_iodous
jingoes153811443jingoes
kiddies133412283kiddies
kiddos12416863kiddo_s
killdees1373963killdees
killies113318113killies
kilos95021473kil_o_s
kilties113014143kilties
kindles123614843kindles
lidos65219883li_do_s
lilies63021413lil_ies
lilos55821873lil_o_s
lindies8416583lindies
lingoes84014693lingoes
lodes66436913__lodes
middies113116153middies
middles113415303middles
midges103516483mi_dges
miladies1139923miladies
milages103114403milages
milded104416153mild_ed
milden94113153mild_en
mildens10339933mildens
milder93818453mild_er
mildest102812063mild_est
mildew12319043mild_ew
mildews13365883mildews
mildness1136523mildness
milds86422053mild__s
miles74645073mil__es
milles84526563mil_les
milos75428013mil_o_s
misdoer1048633misdoer
misdoers1137103misdoers
nides65229133ni_d_es
oilholes1146153oilholes
oldies7314423_oldies
outdoes8313123outdoes
piddles114314273piddles
pileous9510523pileous
piles74742613pil__es
pillows122610123pillows
pilose84514243pil_ose
pilots84018873pil_ots
pilous84717753pil_ous
pilules9510623pilules
pingoes105116523pingoes
pinkoes135512313pinkoes
pintoes95117713pintoes
redoes74623773_redoes
riddles93215023riddles
rides66140813ri_d_es
ridges85817013ri_dges
riles55343643ril__es
rilles64725503ril_les
salvoes102811313salvoes
sides65838363si_d_es
sidles74721153si_dles
silages82514443silages
silanes72517163silanes
silds65520523sild__s
silexes1438653silexes
silkies113715693silkies
sillies73425083sillies
siloed74615303sil_oed
silos56029433sil_o_s
slides73922183slid_es
sloes54728873_sl_oes
tides64830153ti_d_es
tidies74721833ti_dies
tilde65017343tild_e_
tiles55542103til__es
tiptoes939173tiptoes
undoes73917403_undoes
videos104911373vi_deos
villose1038053villose
villous102810023villous
weirdoes12323833weirdoes
weldors11238003weldors
widdies123514033widdies
widdles123514343widdles
wides94832823wi_d_es
widows1376563wi_dows
wilded113714503wild_ed
wilder103616473wild_er
wilders113513503wilders
wildest113311273wild_est
wildness1236203wildness
wilds94818203wild__s
wiles85437873wil__es
willies103920153willies
willows13299753willows
windles113518493windles
windows1447743windows
winoes94317013wi_noes
wisdoms1335453wisdoms
zilches21326303zilches

Search took 10 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.626285448.9
2DLD Change Limit1340273208.58015620.9
3Display Results3203200.1063018.9
 (SQL Overall)1786913209.31219189.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.