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

431 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
zloties163991(None) 
booties94124612booties
clothes124513812clothes
cooties93725732cooties
footies103721542footies
glories81915922glories
looies65025832_looies
lories64933042_lories
lottes65322752_lottes
louies64525102_louies
ologies8615022ologies
platies93722542platies
plotties103111412plotties
plotzes18317702plotzes
zlote143912942zlot_e_
zlotys18374172zlot_ys
zootier163611172zootier
zootiest173311212zootiest
agonies83016623agonies
agouties9337693agouties
alates64833973alat_es
albites9313203albites
alibies9313323alibies
alkies104518093al_kies
allies63827673al_lies
aloes54933673alo__es
aloins65022203alo_ins
amities9317383amities
anomies93316993anomies
atomies93918363atomies
atonies75320953atonies
atopies92816433atopies
aunties73920073aunties
azotes154312223azot_es
azotise1637073azotise
azotises1737603azotises
azotizes1636853azotizes
banties94324763banties
bawties124214313bawties
biotics113812173biotics
biotins93114453biotins
biotites10310083biotites
blasties102113633blasties
blites84721213blit_es
blitzes18408703blitzes
blokes123813883blo_kes
blondes104213163blondes
bloodies11310163bloodies
blooie83913193blooie_
blotches1537433blotches
blotless10347153blotless
blots75626173blot__s
blotted103911833blotted
blotter94612853blotter
blotters104110983blotters
blottier10336413blottier
blottiest11286833blottiest
blouses94014463blouses
blowier1248943blowier
blowiest1337923blowiest
bodies94524143_bodies
bogies94724313_bogies
boites84322703_boites
boobies113718203boobies
boodies103721443boodies
boogies103719013boogies
bookies133819403bookies
boonies93422483boonies
bootees94114473bootees
bootie85421163bootie_
bothies12414783_bothies
butties93217953butties
calories102919563calories
calottes10610083calottes
catties94023053catties
cities84524853_cities
claries93422203claries
clitics11279973clitics
cloches144113713cloches
clones84526563clo_nes
cloques18268563cloques
closes85425593clo_ses
clothe114712993clothe_
clothed134010283clothed
clothier1335363clothier
clothiers1443423clothiers
cloths115512483clot_hs
clots75627643clot__s
clotted104011823clotted
clotures10299023clotures
cloves114918823clo_ves
clozes174915563clo_zes
colies84837053_colies
collies94326583collies
colonies103620013colonies
conies84338593_conies
cookies133719273cookies
coolies93824963coolies
coonties10513803coonties
cootie84223093cootie_
copies104130303_copies
cosies84932153_cosies
cotes76347843_cot_es
cozies174521413_cozies
cronies9622503cronies
culottes1076293culottes
cuties84927363_cuties
cutties93118843cutties
dauties83315763dauties
dawties113312703dawties
deities82621923deities
dhooties1237643dhooties
dhotis1038973dhoti_s
dirties83119383dirties
ditties83116983ditties
dobies94422093_dobies
dogies85022253_dogies
dollies83620983dollies
doobies103915673doobies
doodies94218773doodies
doolies83920713doolies
doozies173812723doozies
dories75232363_dories
dotes65836693_dot_es
dotier73917033_dotier
dotiest83717453_dotiest
doxies143917853_doxies
duties74921903_duties
ebonies9312883ebonies
elates65032363elat_es
elatives1139783elatives
elegies81312903elegies
elites66027123elit_es
eloins65419383elo_ins
elopes85918163elo_pes
elutes64020313elut_es
emotes84620283emot_es
empties11712243empties
epoxies1637753epoxies
erotics91914153erotics
erotizes17311213erotizes
eulogies938523eulogies
exotics16229193exotics
fatties103018203fatties
felonies11310993felonies
fifties132111083fifties
flies85630713fl__ies
flites95122443flit_es
floatier1136983floatier
floatiest1237293floatiest
floes85528143flo__es
flooie93712153flooie_
floosies113210233floosies
floozies20326953floozies
floppies1546823floppies
florins10311643florins
flosses103411973flosses
flossies112810123flossies
flotages1237163flotages
flotas94013003flot_as
flutes95421783flut_es
flutier103011553flutier
flutiest112610883flutiest
flytes123911563flyt_es
flytier13356503flytier
flytiers14254483flytiers
fogies104118063_fogies
folkies143612253folkies
follies103618943follies
foodies113416753foodies
footie94718143footie_
footier104115113footier
footiest113514913footiest
footles103715713footles
footsies1139643footsies
forties104323863forties
glitzes17367563glitzes
globes94314543glo_bes
globins10278953globins
glorias81610323glorias
gloried9169523gloried
glosses84014123glosses
glossies93311253glossies
glottides1163833glottides
glottis837173glottis
glottises1084953glottises
gloves104115183glo_ves
glozes164313353glo_zes
glutes74517673glut_es
gobies95418063_gobies
goodies93516993goodies
goonies83618333goonies
helotries1269563helotries
hogties112813993hogties
holies94630033_holies
hollies103420813hollies
homies114524723_homies
hoodies113419833hoodies
hookies144017443hookies
hootier104915353hootier
hootiest113115643hootiest
hotties103016963hotties
illites72415013illites
iolites73819483iolites
ironies7517423ironies
ivories10310713ivories
jalopies1786673jalopies
jetties143613123jetties
jollies143516273jollies
joltier14318493joltier
joltiest15249403joltiest
jutties143814003jutties
kilties113014143kilties
kitties113213623kitties
klutzes2064113klutzes
ladies75124883_ladies
laities7320343laities
lathes95127503_lathes
latices9313763_latices
latkes104715873_latkes
lattes65324203_lattes
lazies154418783_lazies
lefties10312073lefties
lethes94818083_lethes
levies93919863_levies
lies46454193_l__ies
lilies63021413_lilies
litres65220393_litres
loathes103513243_loathes
loaves94813853_loaves
lobbies113612463_lobbies
lobes75331003_lo_bes
locoes85516583_locoes
lodes66436913_lo_des
lodges86820153_lodges
loftier1037763_loftier
loftiest1139083_loftiest
loges66534203_lo_ges
logics95711123_logics
logier75015733_logier
logiest82515543_logiest
logins77820643_logins
loids66220703_lo_ids
loins56728423_lo_ins
loiter64619173_loiter
loiters74116613_loiters
lollies73116923_lollies
longes75925573_longes
longies82916553_longies
loobies93814103loobies
looie55624243_looie_
loonies73919543loonies
looses67328243_looses
lopes76437343_lo_pes
lores55045403_lo_res
loris55329153_lori_s
lorises73918593_lorises
lorries74518353_lorries
loses56742013_lo_ses
losses65925233_losses
lotahs9479873_lotahs
lotas55926303_lot_as
loti46431843_loti__
lotic76420673_loti_c
lotion65716523_lotion
lotions74614763_lotions
lotos54724633_lot_os
lotoses73713643_lotoses
lots47652093_lot__s
lotte54923853_lotte_
lotted74222403_lotted
lotter64025603_lotter
lotters73921063_lotters
lottos64613103_lottos
lotus55718063_lot_us
lotuses74011253_lotuses
louie55023513_louie_
louis57322323_loui_s
loupes84918053_loupes
louses66230283_louses
loves85332013_lo_ves
lowes85732463_lo_wes
loxes125227473_lo_xes
lunies64723013_lunies
lutes55836663_lut_es
lutzes153711923_lutzes
melodies11310123melodies
miotics112710653miotics
molies84429513_molies
mollies93420233mollies
monies83233163_monies
motes75944003_mot_es
motifs1139673_motifs
motiles93317433_motiles
motives123611893_motives
mottes85523693_mottes
movies115118453_movies
moxies154317403_moxies
myopies14309723myopies
myotics14257603myotics
nasties73520493nasties
nifties102612503nifties
noogies82814583noogies
nookies113414963nookies
notes55034583_not_es
notices9312283_notices
oldies7314423ol_dies
oolites72817843oolites
oologies9312993oologies
ootids71110353_ootids
panties94230933panties
parties93230863parties
pasties94529813pasties
patties93425143patties
peonies93620153peonies
phonies123717513phonies
photics142810483photics
pieties9419223pieties
pities83828083_pities
plates85432243plat_es
platier93716293platier
platiest103216093platiest
plenties10314693plenties
plies74526513pl__ies
ploidies1138173ploidies
plosives1335893plosives
plotless10256793plotless
plotlines1146823plotlines
plots75025673plot__s
plotted104612373plotted
plotter94113663plotter
plotters104011553plotters
plottier10327263plottier
plottiest11287833plottiest
plotzed19376223plotzed
pogies94123543_pogies
pokies125921333_pokies
polies84034583_polies
polities102722343polities
ponies84833463_ponies
posies84431433_posies
posties93128813posties
potpies113116173_potpies
potsies93019483_potsies
potties93723543potties
prosties101421193prosties
proxies163014933proxies
punties94520783punties
putties94420023putties
quotes153312463quot_es
reties65436193_reties
roofies103014413roofies
rookies113917103rookies
roomies93017243roomies
rootier74915393rootier
rootiest83115593rootiest
rootles73215633rootles
rotes56143903_rot_es
rotis56327063_roti_s
rottes64524833_rottes
salties73725773salties
scotias939753scotias
scotties1039753scotties
shorties11414583shorties
shotes95321913shot_es
sixties14310973sixties
slates64934063slat_es
slatier74016813slatier
slatiest82616273slatiest
sloes54728873slo__es
sloids73712693slo_ids
slopes84820453slo_pes
sloshes103811803sloshes
sloths94911893slot_hs
slots54830533slot__s
slotted84613883slotted
slotter73314453slotter
slotters84012403slotters
softies103414613softies
soothes103917113soothes
sootier73916613sootier
sootiest84016753sootiest
sorties74126403sorties
sties55132983__sties
stogies8413693stogies
stories7324273stories
stotins73213873stotins
tatties74120343tatties
ties45248313___ties
titties73617363titties
tobies84521023_tobies
todies74223553_todies
toonies73719883toonies
tootles72915603tootles
tootses72910773tootses
tootsies848613tootsies
tories65435883_tories
totes55139683_tot_es
towies93521193_towies
tutties73216473tutties
unities72520153unities
unties64326923_unties
voltes94915583volt_es
votes84627083_vot_es
votives13337953_votives
whities133113253whities
woodies113517153woodies
woolies104117363woolies
yowies123913733_yowies
zanies153219673z_anies
zaptieh2144563zaptieh
zaptiehs2241863zaptiehs
zealotries1944353zealotries
zeatins16311733zeatins
zeolites1738383zeolites
zestier163010223zestier
zestiest173011103zestiest
zitis145815583z_iti_s
zloty17399793zlot__y
zlotych2441413zlotych
zombies2037993zombies
zones145528043z_o_nes
zooids1637093z_ooids
zooier153411233z_ooier
zooiest16199923z_ooiest
zoologies1939013zoologies
zootomies2046143zootomies
zorils153810883z_orils
zoris145320013z_ori_s
zowie174313843z_owie_
zygotes20355163zygot_es

Search took 7 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.393454684.5
2DLD Change Limit1340274315.53024236.3
3Display Results4314310.1562762.8
 (SQL Overall)1786914316.07929394.8
 
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.