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

367 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
zlotys1837417(None) 
zloty17399791zloty_
blots75626172blot_s
cloths115512482cloths
clots75627642clot_s
cloys104916942clo_ys
flotas94013002flotas
lotas55926302_lotas
lotos54724632_lotos
lots47652092_lot_s
lotus55718062_lotus
platys11459852platys
plots75025672plot_s
ploys105816592plo_ys
sloths94911882sloths
slots54830522slot_s
zlote143912942zlot_e
zloties1639912zloties
zlotych2441412zlotych
zooty175415352zooty_
alates64833963alates
allays94313743allays
alleys95113303alleys
allots64019173allot_s
alloys94014563alloys
aloes54933673alo_es
alohas9411703alohas
aloins65022203aloins
altos55822953al_tos
alts46639903al_t_s
always12409133always
azlons154110423azlo_ns
azotes154312223azotes
azoths18366203azoths
biotas84313923biotas
blats75132503blat_s
blets75324943blet_s
blites84721213blites
bloats85215763bloats
blobs95620033blo_bs
blocks144513943blocks
blocs95219653blo_cs
blogs85319233blo_gs
blokes123813883blokes
blonds95213343blonds
bloods94614843bloods
blooms104613173blooms
bloops106611343bloops
blot65842323blot__
blotch13197143blotch
blotto8198443blotto
blotty11178343blotty
blousy11459123blousy
blowbys17353813blowbys
blows105423833blo_ws
blowsy14579453blowsy
blowy134315323blowy_
blueys11419523blueys
bolts76232113bolt_s
booths115313793booths
boots75837973boot_s
booty106125913booty_
botas75328783_botas
bots66453953_bot_s
botts75224863_botts
boys96737333_bo_ys
broths115013923broths
buoys104810633buo_ys
chotts113610983chotts
clays105521333cl_ays
cloaks124411263cloaks
clocks144916233clocks
clods85320863clo_ds
clogs85519553clo_gs
clomps125212233clomps
clones84526563clones
clonks125013473clonks
clons75228133clo_ns
clonus85212413clonus
cloots85113693cloots
clops95924853clo_ps
closes85425593closes
clot66542423clot__
cloth105817543clot_h
clothe114712993clothe
clothes124513813clothes
clotty11208263clotty
clouds94612353clouds
clours85215083clours
clouts87017203clouts
cloves114918823cloves
clowns114810113clowns
cloy96623833clo_y_
clozes174915563clozes
colbys13407153colbys
colts76633293colt_s
cooeys114914483cooeys
coots75636843coot_s
cotes76347843_cotes
cots68054843_cot_s
coys97537243_co_ys
dhotis1038953dhotis
dolts65626313dolt_s
dotes65836693_dotes
dots55647663_dot_s
doty86128223_doty_
elates65032363elates
elites66027123elites
eloins65419383eloins
elopes85918163elopes
elutes64020313elutes
emotes84620283emotes
flats86429743flat_s
flatus94310783flatus
flays116321053fl_ays
fleys117015603fl_eys
flites95122443flites
flits85625223flit_s
floats96816253floats
floaty124210943floaty_
flocks154713533flocks
flocs105519233flo_cs
floes85528143flo_es
flogs95919963flo_gs
flongs105010493flongs
floods104511653floods
floors94112353floors
floosy12368153floosy
flops105920143flo_ps
floras94715693floras
floss85118263flo_ss
flossy12517703flossy
flota85315643flot_a
flours94414053flours
flouts94315273flouts
flows115822363flo_ws
flutes95421783flutes
fluty114415643fluty_
fluyts12367153fluyts
flybys1792773flybys
flytes123911563flytes
foleys123810463foleys
foots85528283foot_s
footsy12587933footsy
footy115820533footy_
foys105628293_fo_ys
froths125411443froths
gleys96514853gl_eys
gloams95210663gloams
gloats74515423gloats
globes94314543globes
globs85616403glo_bs
gloggs935033gloggs
gloms85219783glo_ms
glomus9468093glomus
glooms96211683glooms
glops85619553glo_ps
glory96413293glory_
gloss64319623glo_ss
glossy10549003glossy
glosts74513813glosts
glottis837163glottis
glouts74414713glouts
gloves104115183gloves
glows95518033glo_ws
glozes164313353glozes
glutes74517673glutes
gluts66120133glut_s
goths96513003_goths
goys86328413_go_ys
grots65025853grot_s
helots95217703helot_s
holts85627913holt_s
hooeys125512313hooeys
hoots84830243hoot_s
hooty115022433hooty_
hots78349323_hot_s
hoys107733933_ho_ys
iotas54821113_iotas
joeys15518043_joeys
jolts125018883jolt_s
jolty155713033jolty_
jotas125717443_jotas
jots116336143_jot_s
joys146624663_jo_ys
klongs11436603klongs
kloofs13386353kloofs
knots95614723knot_s
kotos95717693_kotos
laths86022403_laths
lats45962703_lat_s
lays76043253_l_ays
lets47147943_let_s
leys76430183_l_eys
litas54923773_litas
lits46252493_lit_s
loads65323373_loads
loafs85616993_loafs
loams75619863_loams
loans56026463_loans
lobes75331003_lobes
lobos75921843_lobos
lobs66441083_lo_bs
lochs106715513_lochs
locks115126923_locks
locos75822603_locos
locus74819993_locus
lodes66436913_lodes
loess55714703_loess
lofts85518363_lofts
lofty115813303_lofty_
loges66534203_loges
logos67225333_logos
logs57343113_lo_gs
logy87025783_logy_
loids66220703_loids
loins56728423_loins
lolls512121733_lolls
longs65527063_longs
looeys95110123looeys
loofs85623783_loofs
looks95124863_looks
looms75124643_looms
loons55731723_loons
loops75723963_loops
loos49051123_lo_os
loots55431423_loots
lopes76437343_lopes
lops66043353_lo_ps
lords64923503_lords
lores55045403_lores
loris55329153_loris
lory75931713_lory_
loses56742013_loses
loss45337963_lo_ss
lossy85214643_lossy
lot38179263_lot__
lota47233503_lot_a
lotah85315853_lotah
lotahs9479873_lotahs
loth76132133_lot_h
loti46431833_lot_i
lotic76420663_lotic
lotte54923853_lotte
lottes65322753_lottes
lotto55217573_lotto
lottos64613103_lottos
louis57322323_louis
loups75319623_loups
lours55125293_lours
lousy84617083_lousy
louts56330273_louts
loves85332013_loves
lowes85732463_lowes
lows75843013_lo_ws
loxes125227473_loxes
lutes55836663_lutes
molts76032093molt_s
moots75831663moot_s
motes75944003_motes
moths106021553_moths
mots66853163_mot_s
motts76527003_motts
notes55034583_notes
ology94113113ology_
oots46446443_oot_s
pelotas9410723pelotas
photos113316633photos
phots105418493phot_s
pilots84018873pilot_s
plates85432243plates
plats75531373plat_s
platy105021663platy_
plays106320773pl_ays
plods85719293plo_ds
plonks124210423plonks
plops95920333plo_ps
plot66141233plot__
plotty11208853plotty
plotz164616993plot_z
plotzes18317693plotzes
plows105419903plo_ws
ploy96123603plo_y_
polys105718763_polys
pots66452363_pot_s
potsy105815613_potsy
protyl11308213protyl
protyls12298463protyls
quotas15339433quotas
quotes153312463quotes
riots54922013riot_s
roots55933673root_s
rooty86423023rooty_
rotas54827723_rotas
rotes56143903_rotes
rotis56327053_rotis
rotls55620163_rotls
rotos56027883_rotos
rots46454093_rot_s
ryots85313783ryot_s
scots74025903scot_s
shotes95321893shotes
shots84730833shot_s
shotts93614683shotts
slates64934063slates
slats55436903slat_s
slaty86523153slaty_
slays85723683sl_ays
slits56128853slit_s
slobs74419873slo_bs
sloes54728873slo_es
slogs64521843slo_gs
sloids73712693sloids
slojds14345473slojds
sloops85513623sloops
slopes84820453slopes
slops75026013slo_ps
slot46049823slot__
sloth85019443slot_h
slows85323463slo_ws
sloyd9409683slo_yd
sloyds10346293sloyds
sluts54523983slut_s
snots55225103snot_s
sooths95715583sooths
soots55536203soot_s
sooty84924833sooty_
soths86218623_soths
sots45552443_sot_s
soys75233933_so_ys
spots74424103spot_s
stots54828543stot_s
stotts64612853stotts
swots85518423swot_s
tooths96013803tooths
toots55331873toot_s
tootsy9437983tootsy
totes55139683_totes
tots46654123_tot_s
toys78036343_to_ys
troths95414153troths
trots56629943trot_s
trotyl9236673trotyl
trotyls10236033trotyls
troys86418613tro_ys
voltes94915583voltes
volts85421293volt_s
votes84627083_votes
wots76342893_wot_s
zealots1636763zealot_s
zests145419743zest_s
zesty176512163zesty_
zetas145018163z_etas
zitis145815583z_itis
zits136030293z_it_s
zoeas145815613z_oeas
zones145528043z_ones
zonks184815173z_onks
zooey173914803zooey_
zooids1637093zooids
zooks184716943z_ooks
zooms164415523z_ooms
zoons144919693z_oons
zoos135828803z_o_os
zoris145320013z_oris
zouks184410503z_ouks
zygotes20355163zygotes

Search took 9 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.1231452772.4
2DLD Change Limit1127163678.06313979.4
3Display Results3673670.2361555.1
 (SQL Overall)1786913678.42221217.2
 
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.