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

387 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
kiddies13341228(None) 
biddies113514491biddies
giddies103713361giddies
kiddie12359391kiddie_
kiddoes13387061kiddoes
middies113116151middies
widdies123514031widdies
baddies114017872baddies
birdies104016212birdies
buddies113914352buddies
caddies113718382caddies
cuddies113313262cuddies
daddies103414942daddies
diddles103915072diddles
diddlies1137592diddlies
didies84621832di_dies
eddies83313162_eddies
fiddles123212602fiddles
fuddies123211202fuddies
giddied11257712giddied
giddier10308722giddier
giddiest11298552giddiest
indies73822772_indies
kidded13299382kidd_ed
kidder123811092kidd_er
kidders13399162kidders
kidding14389762kidding
kiddish16276582kiddish
kiddos12416862kidd_os
kidvids1643112kidvids
killies113318112killies
kilties113014142kilties
kindles123614842kindles
kitties113213622kitties
laddies93715052laddies
lindies8416582lindies
middles113415302middles
muddies113513942muddies
neddies92710702neddies
noddies93512042noddies
paddies113715722paddies
piddles114314272piddles
riddles93215022riddles
skiddier1464192skiddier
skiddiest1543812skiddiest
soddies92312852soddies
teddies92711282teddies
tidies74721832ti_dies
toddies93011992toddies
waddies124214752waddies
widdie113410732widdie_
widdles123514342widdles
addles84216603_addles
aides65336603ai_d_es
baddie104114033baddie_
baldies105317703baldies
bandies104124863bandies
bawdies134613393bawdies
beedies10314203beedies
bialies93618413bialies
bidden104010793bidd_en
bidder104114863bidd_er
bidders114012303bidders
bidding123613503bidding
biddings13397553biddings
bides85536773bi_d_es
bidis86721143bi_di_s
biffies152710853biffies
biggies113813523biggies
bikies124515163bi_kies
bilbies114712333bilbies
billies93923503billies
bindis94614583bindi_s
bindles104016453bindles
birdie94013783birdie_
birdied11329433birdied
birkies133712433birkies
bodies94524143_bodies
boodies103721443boodies
buddied12388003buddied
buddles113913073buddles
budgies115312513budgies
burdies104117563burdies
caddices14297853caddices
caddie104316443caddie_
caddied123710563caddied
caddis104613373caddi_s
caddises12329353caddises
candies104125613candies
cissies94116153cissies
cities84524853ci_ties
civies114116443ci_vies
civvies1555843civvies
coddles114213593coddles
cuddie104011173cuddie_
cuddles114014093cuddles
daddles104213803daddles
dandies94121443dandies
diaries83321953diaries
dickies143416343dickies
diddle94915213diddle_
diddled114212053diddled
diddler103511513diddler
diddlers11359153diddlers
diddley13388103diddley
diddleys14334633diddleys
didie74120563di_die_
didoes85716963di_does
dies55653523___dies
dikdiks1242563dikdiks
dildoes9229233dildoes
dillies84122153dillies
dindles93817243dindles
dingies93618243dingies
dinkies123716033dinkies
diodes83915783diod_es
dipodies1238413dipodies
dirties83119383dirties
ditties83116983ditties
divides123211453divides
divvies1457663divvies
dizzies16279753dizzies
doodies94218773doodies
dowdies123412733dowdies
dries64733673__dries
duddie9348863duddie_
eddied9248323_eddied
eddoes8199143_eddoes
edifies113012283edifies
faddier1237783faddier
faddiest1338113faddiest
fiddle113613383fiddle_
fiddled13329633fiddled
fiddler12309953fiddler
fiddlers13328283fiddlers
fidges114114383fi_dges
fifties132111083fifties
fillies103420253fillies
foodies113416753foodies
fuddles123611933fuddles
gaddis94211373gaddi_s
gaudies9311973gaudies
giddily1335073giddily
giddiness1234683giddiness
gillies84120963gillies
gimmies123010103gimmies
gipsies1039903gipsies
girdles92210003girdles
girlies83013703girlies
goodies93516993goodies
griddles1145753griddles
hardies114923233hardies
heddles123311623heddles
hickies163614743hickies
hidden11429743hidd_en
hides95129423hi_d_es
hinnies103615103hinnies
hippies142813743hippies
hissies103915823hissies
hoddins12289373hoddins
hoodies113419833hoodies
howdies142911953howdies
huddles123712573huddles
hurdies114015663hurdies
ides57734233_i_d_es
idles66720123_i_dles
imides94515333_imides
immies102412423_immies
indices103513443_indices
indie63721463_indie_
indites83618983_indites
indues73515263_indues
iodides93811613_iodides
iodids83711143_iodids
iodines83616633_iodines
iodins74216513_iodins
iodise74214933_iodise
iodises83413633_iodises
iodizes173911723_iodizes
irides74519123_irides
ivies84215753_i_vies
jiffies20327473jiffies
jimmies18328773jimmies
kaddish16317973kaddish
kaddishes1844093kaddishes
kadis105921063k_adi_s
kauries113613193kauries
kebbies1537253kebbies
keddahs1642923keddahs
kedges124812943k_edges
kellies113516853kellies
kelpies13289903kelpies
kerries113317913kerries
kewpies16246923kewpies
khadis1446913khadi_s
khedives1942183khedives
kibbes143811193ki_bbes
kibbis14398463kibbi_s
kibbles153510253kibbles
kibeis12469803kibei_s
kibes115521113ki__bes
kickier12349053kickier
kickiest13319673kickiest
kiddo11398943kidd__o
kiddush16242483kiddush
kiddushes1841533kiddushes
kiddy144910273kidd__y
kidlike1137063kidlike
kidnaps1453323kidnaps
kidney1434753ki_dney
kidneys1533423kidneys
kids96029633ki_d__s
kidskins1243453kidskins
kidvid1535023kidvi_d
kikes85122553ki__kes
kilims1277903ki_lims
killdees1373963killdees
killie104114893killie_
kiltie103210963kiltie_
kinases113511123kinases
kinder113716843kind_er
kindest12311503kind_est
kindle114414233kindle_
kindled133410543kindled
kindler12309983kindler
kindlers13318483kindlers
kindless13289243kindless
kindlier1345763kindlier
kindliest1436113kindliest
kindness13236653kindness
kindred13316953kindred
kindreds14274013kindreds
kinds106221813kind__s
kines95039133ki__nes
kineses113111253kineses
kinins104014583ki_nins
kinkier10319433kinkier
kinkiest113110503kinkiest
kirtles11309663kirtles
kishkes1334773kishkes
kisses104217333ki_sses
kites95432543ki__tes
kithes135016653ki_thes
kittles113012493kittles
kiwis12328583ki_wi_s
kludges13397683kludges
koppies153210013koppies
kyries133411373k_yries
laddie83713173laddie_
ladies75124883_ladies
lidded93410243lidd_ed
lidding103611423lidding
lilies63021413li_lies
lipides103810623lipides
lyddites1342583lyddites
meddles113213253meddles
midairs1037193midairs
middays14335663middays
midden104112853midd_en
middens11379373middens
middle103414983middle_
middled123311893middled
middler112712273middler
middlers123410193middlers
midges103516473mi_dges
midis85923403mi_di_s
midlines112613333midlines
midlives14287463midlives
midribs1235493midribs
midwifes17234713midwifes
midwives17274803midwives
miladies1139913miladies
minnies93617363minnies
misdoes10312493misdoes
mislies92922283mislies
missies93423983missies
muddied12339213muddied
muddier114110013muddier
muddiest12298733muddiest
muddles112914353muddles
nidates8311883nidates
nides65229133ni_d_es
nidifies1238233nidifies
niduses837013niduses
nifties102612503nifties
ninnies73713613ninnies
nixies135313873ni_xies
noddles92911293noddles
nudies75217093_nudies
oldies7314423_oldies
paddles113515633paddles
pandies104224503pandies
peddles112913693peddles
piddle103514913piddle_
piddled123311253piddled
piddler112911523piddler
piddlers12359593piddlers
pidgins11259123pidgins
pieties9419223pieties
piggies113813483piggies
pigmies122610993pigmies
pinkies133818263pinkies
pinnies93318443pinnies
pities83828083pi_ties
pixies154915513pi_xies
puddles113613823puddles
raddles93615703raddles
randies84225663randies
readies83324703readies
reddles93315773reddles
redries83721713redries
ridded93615123ridd_ed
ridden83511723ridd_en
ridder84015143ridd_er
ridders93612483ridders
ridding103314183ridding
riddle83915713riddle_
riddled103012043riddled
riddler93411263riddler
riddlers10269103riddlers
rides66140813ri_d_es
ridges85817003ri_dges
ridgier937883ridgier
ridgiest1038903ridgiest
ridgils9326573ridgils
roadies83317433roadies
rowdies113112693rowdies
ruddier9338523ruddier
ruddiest10278543ruddiest
ruddles92813873ruddles
saddles95415743saddles
shindies122610503shindies
shoddies1336043shoddies
sickies133717503sickies
siddurs934173siddurs
sides65838363si_d_es
sidles74721153si_dles
silkies113715693silkies
sillies73425073sillies
sissies73716603sissies
sixties14310973sixties
skidded1465083skidd_ed
skidder1365733skidd_er
skidders1454813skidders
skidding1535463skidding
skiddoos1442113skiddoos
skivvies18112883skivvies
studdies10207073studdies
studies82413863studies
tardies84225863tardies
tidbits1035173tidbits
tiddler93110003tiddler
tiddlers10288653tiddlers
tides64830153ti_d_es
tidied83613273ti_died
tidier73515113ti_dier
tidiers8389773ti_diers
tidiest83514873ti_diest
tildes74513963tild_es
titties73617363titties
tizzies15287893tizzies
toadies82914853toadies
toddles93211533toddles
todies74223553_todies
twiddles13265613twiddles
undies73821963_undies
updries10209083updries
vichies15310623vichies
waddie114013323waddie_
waddied13358563waddied
waddles124314843waddles
wadies105121203_wadies
wedgies123910203wedgies
weirdies12255783weirdies
widder112913973widd_er
widders123512263widders
widdle113814843widdle_
widdled133511233widdled
wides94832823wi_d_es
wienies102213683wienies
willies103920153willies
windier113412163windier
windiest122213233windiest
windles113518493windles
withies133913543withies
woodies113517153woodies
yippies14279293yippies

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273877.20318607.1
3Display Results3873870.1402764.3
 (SQL Overall)1786913877.49923828.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.