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

273 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
puzzle1631860(None) 
guzzle15297911guzzle
muzzle16319391muzzle
nuzzle14298081nuzzle
pizzle16279491pizzle
puzzled18286651puzzled
puzzler17276961puzzler
puzzles17318971puzzles
dazzle1536852dazzle
fizzle17369712fizzle
guzzled17326262guzzled
guzzler16286562guzzler
guzzles16328042guzzles
mizzle16279992mizzle
muzzled18267752muzzled
muzzler17257942muzzler
muzzles17299682muzzles
nozzle14236632nozzle
nuzzled16276392nuzzled
nuzzler15296492nuzzler
nuzzles15298122nuzzles
pizzles17329272pizzles
pozole1758912pozole
puddle103914152puddle
pule65040952pu__le
pungle94413572pungle
purfle112511182purfle
purple102712672purple
puzzlers18295142puzzlers
sizzle14309612sizzle
unpuzzle1842302unpuzzle
zizzle13247312zizzle
audile73315303audile
azole145118033_azole
bemuzzle2072533bemuzzle
bubale104014623bubale
bubble94016593bubble
buckle144815193buckle
buddle104313083buddle
bugle84721943bu_gle
bumble124216893bumble
bundle94315573bundle
bungle97116113bungle
burble104617703burble
burgle94815863burgle
bustle84015483bustle
butle75023103bu_tle
buzz146617803buzz__
buzzed17408473buzzed
buzzer16379113buzzer
buzzes165011173buzzes
cuddle104414533cuddle
cupule103410723cupule
curdle95514313curdle
curule83614123curule
cuttle84113893cuttle
dazzled1735033dazzled
dazzler1634713dazzler
dazzles1636413dazzles
drizzle16285913drizzle
duffle13368533duffle
duple85315863du_ple
fizzled19357273fizzled
fizzles18339063fizzles
foozle18369203foozle
frazzle18305223frazzle
frizzle18367043frizzle
fuddle113312103fuddle
fugle94915543fu_gle
fumble133214263fumble
furze176815813furz_e
fusile94313493fusile
futile93914953futile
fuze166422373fu_z_e
fuzee175718883fu_zee
fuzil173810703fuzil_
fuzils18407963fuzils
fuzz158420573fuzz__
fuzzed18479253fuzzed
fuzzes175412253fuzzes
fuzzier18256523fuzzier
fuzzily2145073fuzzily
fuzzy1929814513fuzz_y
grizzle16306113grizzle
guggle94110433guggle
guile64521133gu_ile
gurgle83912473gurgle
guttle74111973guttle
guzzlers17274863guzzlers
huckle153913073huckle
huddle113712993huddle
humble133615053humble
hurdle103712793hurdle
hurtle93512943hurtle
hustle93113993hustle
huzza1646093huzz_a
huzzaed1943103huzzaed
huzzah2044423huzzah
huzzas1735863huzzas
jubile152910263jubile
juggle154310283juggle
jumble174012653jumble
jungle144012653jungle
justle133211583justle
lezzie1435333lezzie
lunule638433lunule
mizzled18327633mizzled
mizzles17329493mizzles
mizzly19256103mizzly
muckle143413583muckle
muddle103414633muddle
muffle14339643muffle
mule65236973mu__le
mumble123614343mumble
muscle10310973muscle
mutule8311423mutule
muzzier17326553muzzier
muzzily2045023muzzily
muzzlers18245203muzzlers
muzzy188410603muzz_y
nozzles15276303nozzles
nubble103813713nubble
nubile83212713nubile
nuncle839363nuncle
nuzzlers16244753nuzzlers
ouzel144612323ouzel_
ouzels15408703ouzels
paddle104615143paddle
padle84522343p_adle
pale66055013p__ale
papule102212133papule
parle75836163p_arle
parole84425253parole
pebble1238003pebble
peddle103512823peddle
pele65539553p__ele
penile82219603penile
people10310183people
pestle83215843pestle
pettle84116053pettle
phyle134111153p_hyle
piazze1634683piazze
pickle144215653pickle
piddle103514913piddle
piffle14418233piffle
pile65649693p__ile
pilule8411123pilule
pimple123512963pimple
pinole83218783pinole
pintle83818263pintle
pizza1538183pizz_a
pizzas1646983pizzas
pizzaz1565443pizzaz
pizzelle1842913pizzelle
plumule1134303plumule
pole65951303p__ole
poodle93112043poodle
popple92710983popple
posole8314223posole
pottle84416103pottle
pozoles1839063pozoles
prize164718943priz_e
prole74527793p_role
puce85127883pu__ce
puddled123011193puddled
puddler112910753puddler
puddles113613823puddles
puddly13438133puddly
pueblo1035553pueblo
puerile9310093puerile
pugree92112473pugree
puisne856353puisne
puke105025463pu__ke
pul56138063pu__l_
pula65129373pu__la
puled84926523pu__led
puler74826623pu__ler
pules74538813pu__les
puli65527623pu__li
pull64731663pu__ll
pulled94322193pu_lled
puller83820813pu_ller
pullet84026333pu_llet
pulley113713403pu_lley
pulls74425053pu_lls
pulp84825353pu__lp
pulque1736213pulque
puls65437563pu__ls
pulse74219973pu_lse
pumelo10257113pumelo
pumice1238223pumice
pummel12278043pummel
pungled114210083pungled
pungles104013713pungles
punily11311773punily
punkie123513613punkie
pupae96515643pu_pae
pupal97616873pupal_
pupate104213123pupate
pupil94712983pupil_
pupils10389913pupils
pure65543333pu__re
puree74632843pu_ree
purely114013613purely
purfled13248723purfled
purfler12248733purfler
purfles122511843purfles
purge85324603pu_rge
purine85321893purine
purl65631423pu_rl_
purled94520743pu_rled
purls74723353pu_rls
purpled12299763purpled
purpler11289263purpler
purples112712823purples
purply13369043purply
purse76028893pu_rse
pursue84512253pursue
pusley11379613pu_sley
pussley12375123pussley
pussly11407373pussly
pustule937683pustule
puttee85919723puttee
puttie84116303puttie
putz158326323putz__
putzed18409113putzed
putzes174212523putzes
puzzledly2361163puzzledly
puzzling19225393puzzling
quale143617853qu_ale
rubble104315673rubble
ruble74521253ru_ble
ruckle124414583ruckle
ruddle83414203ruddle
ruffle124111673ruffle
rule49938423ru__le
rumble103718813rumble
rumple103913013rumple
rundle73214233rundle
runkle103611543runkle
rustle63615413rustle
rutile65217683rutile
sizzled16367883sizzled
sizzler15266863sizzler
sizzles15349633sizzles
sozzled16265183sozzled
spatzle1834573spatzle
spurtle937453spurtle
suable83920553suable
subtle82113433subtle
suckle124015963suckle
supple10410203supple
swizzle1854103swizzle
tazze1339573tazz_e
teazle15329553teazle
touzle15429003touzle
tubule839853tubule
tuille63012643tuille
tule45735873tu__le
tulle54019933tu_lle
tumble103215643tumble
turtle63213573turtle
tussle637143tussle
uncle7317053_uncle
unmuzzle1842303unmuzzle
unpuzzled2042253unpuzzled
unpuzzles1941823unpuzzles
uppile10178503uppile
utile54718933_utile
wurzel1834993wurzel
yule75725143yu__le
zizzled15315853zizzled
zizzles14307093zizzles

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162737.50015028.8
3Display Results2732730.0962843.8
 (SQL Overall)1786912737.73623098.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.