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

182 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
puzzling1922539(None) 
guzzling18225061guzzling
muzzling19245731muzzling
nuzzling17224771nuzzling
buzzing18186542buzz_ing
dazzling1834362dazzling
fizzling20264992fizzling
fuzzing19336182fuzz_ing
huzzaing2042432huzzaing
mizzling19255442mizzling
puddling13218032puddling
puling93621402pu__ling
pulling103821072pu_lling
pungling12228662pungling
purfling1467762purfling
purling103620292pu_rling
purpling1368542purpling
putzing19359122putz_ing
puzzlingly2441882puzzlingly
sizzling17225782sizzling
unpuzzling2141572unpuzzling
zizzling16233922zizzling
bemuzzling2341383bemuzzling
bubbling12248223bubbling
buckling17259113buckling
bugling113615343bu_gling
bulling104324793bu_lling
bumbling15249763bumbling
bundling12219703bundling
bungling12269543bungling
burbling13249423burbling
burgling12239303burgling
burling104421133bu_rling
bustling112110063bustling
butling103516813bu_tling
buzzwig2141993buzzwi_g
cuddling13287653cuddling
culling103921303cu_lling
cupeling1338863cupeling
curdling12228893curdling
curling104320183cu_rling
cuttling1138203cuttling
dizzying2133023dizzying
drizzling1943023drizzling
duckling16247703duckling
dueling93614543du_eling
duelling103410733duelling
dulling93418273du_lling
dumpling14217893dumpling
fizzing19276403fizz_ing
foozling21275723foozling
frazzling2143153frazzling
frizzling2153113frizzling
fuddling14247153fuddling
fueling113615133fu_eling
fuelling123410153fuelling
fugling124212513fu_gling
fulling114019703fu_lling
fumbling16208163fumbling
furling114016563fu_rling
futzing20307903futz_ing
fuzing194110643fu_z_ing
grizzling1942843grizzling
guggling10236353guggling
guiling93214213gu_iling
gulling94019563gu_lling
gurgling11267323gurgling
guttling1037293guttling
huddling14227293huddling
hulling113619013hu_lling
humbling16208673humbling
hurdling13288013hurdling
hurling113616413hu_rling
hurtling12318313hurtling
hustling12228793hustling
huzzahing2441113huzzahing
jazzing2333883jazz_ing
juggling18225603juggling
jumbling20217233jumbling
justling16207253justling
lulling83616803lu_lling
muddling13268593muddling
muffling1765503muffling
muling93519883mu__ling
mulling103819993mu_lling
mumbling15198533mumbling
muscling1337853muscling
nudzhing2242033nudzhing
nulling83818063nu_lling
nurling84215823nu_rling
nursling997603nursling
paddling13218643paddling
paling93530133p__aling
palling104024483p_alling
paneling111013623paneling
parling103823763p_arling
paroling113316213paroling
pealing104123203p_ealing
pearling11912003pearling
pebbling1535073pebbling
pedaling122412133pedaling
peddling13217973peddling
peeling102919873p_eeling
peopling1338353peopling
periling11316863periling
pestling111010253pestling
pettling1168213pettling
pickling17239203pickling
piddling13208943piddling
piffling1745133piffling
piling95025593p__iling
pilling103722563p_illing
pindling122110983pindling
poling93526503p__oling
polling102920383p_olling
pooling103219093p_ooling
poppling12227323poppling
prilling113413413prilling
prizing193514683priz_ing
prowling1449993prowling
pudding124010803pu_dding
puddlings14243783puddlings
puffing162910943pu_ffing
pugging122912543pu_gging
puking133913063pu__king
pulings103511323pu__lings
pulping123612323pu_lping
pulsing103712863pu_lsing
pumicing1535843pumicing
pummeling1643603pummeling
pumping144213553pu_mping
punching163310123punching
punning103414993pu_nning
punting103318443pu_nting
pupating1337683pupating
pupping114412503pu_pping
purblind1345163purblind
pureeing1137273pureeing
purflings1554093purflings
purging113314183pu_rging
purlin83615863pu_rlin_
purline93516533pu_rline
purlings113910283pu_rlings
purlins93415423pu_rlins
purring104515823pu_rring
pursing103715553pu_rsing
pursuing1146233pursuing
pushing133615453pu_shing
putting103218573pu_tting
puttying1434953puttying
puzzle16318603puzzl__e
puzzled18286653puzzl_ed
puzzler17276963puzzl_er
puzzlers18295143puzzlers
puzzles17318973puzzl_es
quailing1838403quailing
quelling18259793quelling
quilling182510003quilling
quisling18218063quisling
quizzing2643403quizzing
razzing1636323razz_ing
rubbling13238073rubbling
ruckling15258573ruckling
ruddling11228553ruddling
ruffling1546093ruffling
ruling73219553ru__ling
rumbling131910103rumbling
rumpling13178763rumpling
runkling13217613runkling
rustling9249983rustling
suckling152410023suckling
suppling1359043suppling
swizzling2142493swizzling
teazling1856573teazling
touzling1835503touzling
tumbling13219293tumbling
turtling9238833turtling
tussling935823tussling
unmuzzling2141593unmuzzling
unsling8313643_unsling
upfling1337093_upfling
uppiling1335853uppiling

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621828.33017546.5
3Display Results1821820.0762394.7
 (SQL Overall)1786911828.56220870.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.