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 “puling” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

177 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
puling9362140(None) 
muling93519881muling
paling93530131paling
piling95025591piling
poling93526501poling
puking133913061puking
pulings103511321pulings
pulling103821071pulling
pulping123612321pulping
pulsing103712861pulsing
purling103620291purling
ruling73219551ruling
ailing74331012ailing
auding83616932auding
baling94829692baling
bluing94914482bluing
bugling113615342bugling
bulging113514212bulging
bulking143815122bulking
bulling104324792bulling
burling104421132burling
busing96420592busing
butling103516812butling
buying124213832buying
cling86424672_cling
cluing93913502cluing
cubing114213952cubing
cueing94913612cueing
cuing85420192cu_ing
culling103921302culling
culming123811182culming
curing94824782curing
curling104320182curling
doling84923132doling
duding93913322duding
dueling93614542dueling
duking124715132duking
dulling93418272dulling
duping104113632duping
during84419402during
filing103823762filing
fling97023512_fling
fouling113315372fouling
fueling113615132fueling
fugling124212512fugling
fulling114019702fulling
fuming124013292fuming
furling114016562furling
fusing104415952fusing
fuzing194110642fuzing
gluing83812052gluing
guiling93214212guiling
gulfing12339472gulfing
gulling94019562gulling
gulping11309752gulping
guying11379722guying
haling104229782haling
hauling113714432hauling
holing104025072holing
hulking153910982hulking
hulling113619012hulling
hurling113616412hurling
idling8912882idling
isling71213882isling
juking183810472juking
ling57447962__ling
lubing94114042lubing
luging83915292luging
lulling83616802lulling
luring73820752luring
luting75221752luting
mauling103315682mauling
mulling103819992mulling
muring95120372muring
musing93919502musing
muting93921522muting
nuking113411252nuking
nulling83818062nulling
nurling84215822nurling
ogling83211882ogling
oiling74925312oiling
outing74128152outing
pacing114522752pacing
paging104020402paging
palings103915822palings
palling104024482palling
palming123914012palming
palping124112872palping
paring94236492paring
parling103823762parling
paulin8312982paulin_
paulins9312612paulins
pausing103912812pausing
paving124519742paving
pawing124519552pawing
paying123722162paying
pealing104123202pealing
peeing94618082peeing
peeling102919872peeling
pelting102917272pelting
pieing93917652pieing
piing85218832p_iing
piking133719642piking
pilings103313612pilings
pilling103722562pilling
ping75943592p__ing
pining93726532pining
piping114017452piping
plink115219122p_link
pluming123412042pluming
plying124312082plying
poking133819302poking
polling102920382polling
pooing93820682pooing
pooling103219092pooling
poring94227272poring
posing93922642posing
pouring103115862pouring
pouting103519942pouting
poxing163714942poxing
pruning10311732pruning
prying124114802prying
pudding124010802pudding
puddling13218032puddling
puffing162910942puffing
pugging122912542pugging
puli65527622puli__
pulik113613302puli_k
pulingly1436802pulingly
pulis74225602puli_s
pulvini1235072pulvini
pumping144213552pumping
pung75429632pu__ng
pungling12228662pungling
punning103414992punning
punting103318442punting
pupping114412502pupping
purfling1467762purfling
purging113314182purging
purin75527592purin_
purine85321892purine
purins83722652purins
purlin83615862purlin_
purline93516532purline
purlings113910282purlings
purlins93415422purlins
purpling1368542purpling
purring104515822purring
pursing103715552pursing
pushing133615452pushing
putting103218572putting
putzing19359122putzing
puzzling19225392puzzling
riling74227972riling
ruing67221052ru_ing
rulings83310382rulings
sling66028802_sling
sluing74315882sluing
soling74226822soling
spiling102919702spiling
spuing94313362spu_ing
spuming1248522spuming
suing65026362su_ing
sulking124514312sulking
tiling73426552tiling
toling73926122toling
tubing93813092tubing
tuning74016842tuning
upfling1337092upfling
uplink12388712uplink
upping114013702upping
using66317962_using
voling103918022voling
waling104525302waling
wauling112713112wauling
wiling103024292wiling
wyling13368552wyling

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511772.53332590.2
3Display Results1771770.0632809.5
 (SQL Overall)1786911772.93960799.9
 
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.