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

359 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
plotzes1831770(None) 
plotzed19376221plotzed
blitzes18408702blitzes
clothes124513812clothes
clozes174915562clo_zes
glitzes17367562glitzes
glozes164313352glo_zes
klutzes2064112klutzes
lottes65322752_lottes
lutzes153711922_lutzes
plates85432242plat_es
platies93722542platies
plotless10256792plotless
plots75025672plot__s
plotted104612372plotted
plotter94113662plotter
plotters104011552plotters
plotties103111412plotties
plotz164617002plotz__
potzer174411212p_otzer
potzers184010542p_otzers
putzes174212522p_utzes
zloties1639912zloties
alates64833963alat_es
aloes54933673alo__es
aplites9314933aplit_es
azotes154312223azot_es
azotizes1636853azotizes
blazes174817353bl_azes
blintzes1944263blintzes
blites84721213blit_es
blitzed19336533blitzed
blitzer18447663blitzer
blitzers19417153blitzers
blokes123813883blo_kes
blondes104213163blondes
blotches1537433blotches
blotless10347153blotless
blots75626173blot__s
blotted103911833blotted
blotter94612853blotter
blotters104110983blotters
blouses94014463blouses
blowzed22435973blowzed
bonzes175116103_bonzes
bootees94114473bootees
booties94124613booties
boozes174916523_boozes
bortzes1838223bortzes
bronzes183510403bronzes
calottes10610083calottes
cloches144113713cloches
clones84526563clo_nes
cloques18268563cloques
closes85425593clo_ses
clothe114712993clothe_
clothed134010283clothed
cloths115512483clot_hs
clots75627643clot__s
clotted104011823clotted
clotures10299023clotures
cloves114918823clo_ves
cloze165517543clo_ze_
cooties93725733cooties
cotes76347843_cot_es
cozes166033243_co_zes
cozzes164510893_cozzes
crozes174417663cro_zes
culottes1076293culottes
ditzes163212423_ditzes
dotes65836693_dot_es
dozes155226303_do_zes
elates65032363elat_es
elites66027123elit_es
elopes85918163elo_pes
elutes64020313elut_es
emotes84620283emot_es
erotizes17311213erotizes
flites95122443flit_es
floes85528143flo__es
floozies20326953floozies
flosses103411973flosses
flotages1237163flotages
flotas94013003flot_as
flutes95421783flut_es
flytes123911563flyt_es
footies103721543footies
footles103715713footles
fritzes19329453fritzes
futzes184313113_futzes
glazes165315643gl_azes
glitzed18375493glitzed
globes94314543glo_bes
glories81915913glories
glosses84014123glosses
glottis837173glottis
gloves104115183glo_ves
gloze154815983glo_ze_
glozed173711223glo_zed
glutes74517673glut_es
hertzes1938303hertzes
lathes95127493_lathes
latkes104715873_latkes
lattes65324203_lattes
lazes145129573_l_azes
lethes94818083_lethes
lezzes14387833_lezzes
litres65220393_litres
loathes103513243_loathes
loaves94813853_loaves
lobes75331003_lo_bes
locoes85516583_locoes
lodes66436913_lo_des
lodges86820153_lodges
loges66534203_lo_ges
longes75925573_longes
looies65025833_looies
looses67328243_looses
lopes76437343_lo_pes
lores55045403_lo_res
lories64933043_lories
loses56742013_lo_ses
losses65925233_losses
lotahs9479873_lotahs
lotas55926303_lot_as
lotos54724633_lot_os
lotoses73713643_lotoses
lots47652093_lot__s
lotte54923853_lotte_
lotted74222403_lotted
lotter64025603_lotter
lotters73921063_lotters
lottos64613103_lottos
lotus55718063_lot_us
lotuses74011253_lotuses
louies64525103_louies
loupes84918053_loupes
louses66230283_louses
loves85332013_lo_ves
lowes85732463_lo_wes
loxes125227473_lo_xes
lutes55836663_lut_es
motes75944003_mot_es
mottes85523693_mottes
notes55034583_not_es
ologies8615023ologies
oozes145418713__oozes
palates93624933palat_es
palettes103112833palettes
panties94230933panties
parties93230863parties
pastes85233913past_es
pasties94529813pasties
pates76047893p_at_es
patties93425143patties
patzer173111643p_atzer
patzers184210573p_atzers
pectizes21229793pectizes
pelites93821993pelit_es
pelotas9410723pelot_as
pelotons1038913pelotons
peones83821043peo_nes
peonies93620153peonies
peoples11312223peoples
peptizes21269853peptizes
pestles93217693pestles
pettles93916483pettles
peyotes1238483peyot_es
phizes20389133p_hizes
phloxes1935513phlo_xes
phoebes1435813phoebes
phones114121213pho_nes
phonies123717513phonies
photics142810483photics
photoed1338913photoed
photogs13358213photogs
photons123814433photons
photos113316643phot_os
phots105418503phot__s
picotees1247113picotees
pieties9419223pieties
pilotages1245503pilotages
piloted10310323pilot_ed
pilotless1143993pilotless
pilots84018873pilot__s
pintles94118723pintles
pintoes95117713pintoes
pistes85325633pist_es
pities83828083p_ities
places104323703pl_aces
plages94520153pl_ages
plagues103311063plagues
plaices11411143plaices
planes85028083pl_anes
plaques18317893plaques
plashes124417393plashes
platanes102711883platanes
platans93413123platans
plate74635113plat_e_
plated95225773plat_ed
platen84518203plat_en
platens94213983platens
plater84427693plat_er
platers93924093platers
platier93716293platier
platiest103216083platiest
plats75531373plat__s
platted103614263platted
platter93917413platter
platters103415283platters
platys11459853plat_ys
plazas17409913pl_azas
pleases94515483pleases
plebes104313623pl_ebes
pledges113811583pledges
plenties10314693plenties
plexes155313543pl_exes
plies74526513pl__ies
plisses94411773plisses
plodded1265563plodded
plodder1146003plodder
plodders1235523plodders
plods85719293plo__ds
ploidies1138173ploidies
plonked14348103plonked
plonks124210423plo_nks
plopped11288773plopped
plops95920333plo__ps
plosives1335893plosives
plot66141233plot___
plotlines1146823plotlines
plottages1244243plottages
plottier10327263plottier
plottiest11287833plottiest
plotty11208853plot_ty
plotzing20276153plotzing
ploughs13526103ploughs
plover115312613plo_ver
plovers123611833plovers
plowed124213203plo_wed
plower114315063plo_wer
plowers123812243plowers
plowmen1434883plowmen
plows105419903plo__ws
ployed124310563plo_yed
ploys105816593plo__ys
plumes104318133pl_umes
plunges104011613plunges
pluses83618073pl_uses
plushes124313673plushes
plusses93510693plusses
plutei8408903plut_ei
pluteus9326243pluteus
plutons938343plutons
poetizes19310253poetizes
pogies94123543p_ogies
poises84226543p_oises
pokes116133013p_o_kes
pokies125921333p_okies
poles75351003p_o_les
polices113118053polices
polies84034583p_olies
polities102722343polities
pollees93215333pollees
pomes94833933p_o_mes
ponces104720843p_onces
pones74547043p_o_nes
ponies84833463p_onies
pontes83627853p_ontes
pooches143214163pooches
poodles103013513poodles
pooves113914713p_ooves
popes95933813p_o_pes
pores75849033p_o_res
poses74642763p_o_ses
posies84431433p_osies
posses85128803p_osses
posties93128813posties
potages102416423p_otages
poteen83514263p_oteen
poteens92910883p_oteens
pother113818853p_other
pothers123818623p_others
pothos114214693p_othos
potmen102713093p_otmen
potpies113116173p_otpies
pots66452363p_ot__s
potsies93019483p_otsies
potted94624013p_otted
potter83926983p_otter
potters94024343p_otters
potties93723543potties
pottles93816983pottles
pottos84615873p_ottos
poxes145325723p_o_xes
prates84633163prat_es
pretzel1835143pretzel
pretzels1934033pretzels
prezes173614693p_rezes
prizes173819813p_rizes
probes104119453pro_bes
proettes10312763proettes
proles84627203pro_les
proses84733473pro_ses
prosses94019513prosses
prosties101421193prosties
protases102115033protases
protea82214763prot_ea
proteas92015123proteas
proteges1149923proteges
protei82615313prot_ei
protest9317533prot_est
proteus92511593proteus
protons93118003protons
protyles13249833protyles
protyls12298463protyls
proves114322253pro_ves
proxies163014933proxies
ptoses83514673pto_ses
punties94520783punties
puttees93612913puttees
putties94420023putties
putzed18409113p_utzed
pyoses114314303pyo_ses
quotes153312463quot_es
ritzes154812943_ritzes
rootles73215633rootles
rotes56143903_rot_es
rottes64524833_rottes
shotes95321913shot_es
slates64934063slat_es
sleazes162810333sleazes
sloes54728873slo__es
slopes84820453slo_pes
sloshes103811803sloshes
sloths94911893slot_hs
slots54830533slot__s
slotted84613883slotted
slotter73314453slotter
slotters84012403slotters
snoozes16289783snoozes
soothes103917113soothes
speltzes1944003speltzes
spitzes1849183spitzes
splodges1234153splodges
splores91910953splo_res
sploshes1336133sploshes
splotches1643913splotches
spritzes1946943spritzes
tootles72915603tootles
tootses72910773tootses
totes55139683_tot_es
tzetzes1532673tzetzes
voltes94915583volt_es
votes84627083_vot_es
waltzes1935953waltzes
yutzes18408413_yutzes
zlote143912943zlot_e_
zlotys18374173zlot_ys

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.406440125.6
2DLD Change Limit1340273596.83019623.3
3Display Results3593590.1232918.7
 (SQL Overall)1786913597.35924282.0
 
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.