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

248 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
dollops1028796(None) 
collops112611751collops
dollop9259361dollop_
lollops9227441lollops
collop107312312collop_
doblons1037042doblons
dollars83311022dollars
dollies83620982dollies
dolloped1234982dolloped
dolls66126922doll__s
dolors75115312do_lors
doowops1363942doowops
follows13409922follows
gallops103211652gallops
holloas103814942holloas
holloes103818192holloes
holloos104013582holloos
hollos95320632hollo_s
hollows134412332hollows
lollop8238782lollop_
lollopy12234772lollopy
orlops847302_orlops
rollmops1243002rollmops
scollops12235702scollops
trollops1044812trollops
wallops123410412wallops
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
apollos946793apollo_s
ballons93916963ballons
ballots94116033ballots
bellhops1544873bellhops
bellows124313303bellows
billons93013363billons
billows123611293billows
bloops106611343_bloops
bollocks1636503bollocks
bollox1548743bollo_x
bolloxes1736833bolloxes
bolls75531313boll__s
bolos75531373bo_lo_s
bolsons969483bolsons
bullous9311663bullous
callous93516603callous
cellos84517803cello_s
clops95924853__clops
coeloms1139063coeloms
collapse1244273collapse
collars93816573collars
collets93517903collets
collies94326583collies
collins93419833collins
colloid10312883colloid
colloids11310173colloids
cologs96517353co_logs
colons86028683co_lons
colors86622373co_lors
coops96229643co__ops
coplots11511593coplots
cowflops1842983cowflops
cowplops1743173cowplops
cyclops1635383cyclops
dalles74222063dall_es
dallies84023193dallies
daltons8310403daltons
dellies83622213dellies
dells66630943dell__s
deploys1336523deploys
develops14145323develops
dewlaps1334663dewlaps
dialogs938103dialogs
diglots9299503diglots
dildoes9229243dildoes
dildos8179303dildo_s
dillies84122163dillies
dills65530973dill__s
diploes101111493diploes
doblas93812293dobl_as
doblon938013doblo_n
doblones1136763doblones
dobros93910233dobro_s
dobsons1036203dobsons
doctors1039993doctors
dodoes85716103do_does
dodos75819393do_do_s
dogdoms1295423dogdoms
doglegs1034783doglegs
dognaps1134393dognaps
doilies84017363doilies
dojos135111793do_jo_s
doles67843753do_l_es
doll56632493doll___
dollar74110983doll_ar
dolled83518073doll_ed
dollhouse1344053dollhouse
dollied93811143dollied
dolling93817373dolling
dollish11610093dollish
dolloping1344993dolloping
dolly96125203doll__y
dolmans10479683dolmans
dolmas95213043do_lmas
dolmens10388693dolmens
dolor67617963do_lo_r
dolorous947843dolorous
dolour75710133do_lour
dolours8438823dolours
dols56943053do_l__s
dolts65626313do_l_ts
donjons1536733donjons
donors75115793do_nors
doodoos9107623doodoos
doolees83711613doolees
doolies83920713doolies
dooms85321343do__oms
doors65022133do__ors
doowop1283853doowop_
dorps85419223do__rps
doulas75114993doul_as
doyleys14384923doyleys
doylies114512573doylies
drolls75312393droll__s
droops95110963d_roops
drops85719503d__rops
drylots1143743drylots
duellos845763duello_s
dulls64523743dull__s
duologs935363duologs
fallows133713973fallows
felloes104114383felloes
fellows134212433fellows
fillips12298133fillips
fillos94415083fillo_s
flops105920143__flops
foldups1332733foldups
folios93915463folio_s
folious103710733folious
folles93820473foll_es
follies103618943follies
follis93113903foll_is
follow124010353follo_w
followups1742293followups
gallons83015953gallons
gallop93311383gallop_
gallous82813953gallous
gallows113513513gallows
galops94712623_galops
glops85619553__glops
goops86620963go__ops
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallows134417393hallows
helloes103717463helloes
hellos95321683hello_s
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
hilltops1344933hilltops
holdups1333593holdups
hollas94616903holl_as
hollers103818233hollers
hollies103420813hollies
hollo84822163hollo__
holloa94914823hollo_a
holloed113812753holloed
holloo94415253hollo_o
hollow124212663hollo_w
hoops105621073ho__ops
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
jalops15329593_jalops
jellos134714283jello_s
jollies143516273jollies
joypops2162603joypops
kolos94921213ko_lo_s
lollers72713793lollers
lollies73116923lollies
lollipops1341783lollipops
lolloped1134463lolloped
lolls512121733loll__s
lollypops1651953lollypops
loops75723963__loops
lops66043353___lops
mallows123714323mallows
mellows123812233mellows
mollahs12328283mollahs
mollies93420233mollies
molls75129783moll__s
nolos54423353no_lo_s
oleos55419683_oleo_s
olios54520853_olio_s
ollas54218283_oll_as
oops65232673_o__ops
orlons6411013_orlons
orlop7410903_orlop_
oxlips1544433_oxlips
pallors9314363pallors
pillows122610123pillows
plops95920333__plops
polios84019723polio_s
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
pollock1546843pollock
pollocks1656473pollocks
polls74627723poll__s
polos76129913po_lo_s
polyols1238493polyols
polyps13479763po_lyps
poops94422413po__ops
postops11311713postops
pullups1134233pullups
rollers73117473rollers
rollmop1142993rollmop_
rollout7811943rollout
rollouts8136733rollouts
rolls55326233roll__s
rolltop944043rolltop_
sallows103915553sallows
saloops93510133saloops
scallops12297393scallops
scollop11275433scollop_
shallops13288323shallops
sloops85513623_sloops
slops75026013__slops
solions7513753solions
solons65120023so_lons
solos54830793so_lo_s
tallols73311363tallols
tallows103313743tallows
tollers73217463tollers
tolls54728433toll__s
toluols735823toluols
trollop944793trollop_
trollopy1343273trollopy
villous102810023villous
volleys13316643volleys
wallop113310293wallop_
wallows133613533wallows
willows13299753willows
woops104917523wo__ops
yellows13329603yellows

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 Limit1340272486.70319995.1
3Display Results2482480.0763263.2
 (SQL Overall)1786912487.18524870.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.