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

295 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
dollop925936(None) 
collop107312311collop
dollops10287961dollops
lollop8238781lollop
bollox1548742bollox
collops112611752collops
doblon938012doblon
doll56632492doll__
dollar74110982dollar
dolled83518072dolled
dolloped1234982dolloped
dolls66126922doll_s
dolly96125202doll_y
dolor67617962do_lor
doowop1283852doowop
follow124010352follow
gallop93311382gallop
hollo84822162hollo_
holloa94914822holloa
holloo94415252holloo
hollos95320632hollos
hollow124212662hollow
lollops9227442lollops
lollopy12234772lollopy
orlop7410902_orlop
rollmop1142992rollmop
rolltop944042rolltop
scollop11275432scollop
trollop944792trollop
wallop113310292wallop
allod64418383_allod
allot54933873_allot
allow85420663_allow
alloy85519973_alloy
apollo837183apollo_
apollos946793apollos
ballon84117493ballon
ballot84624093ballot
bellhop1445053bellhop
bellow114213353bellow
billon83713833billon
billow114111223billow
bloop96116153_bloop
boll65634753boll__
bolled94722653bolled
bollix1538053bollix
bolls75531313boll_s
bolo65535953bo_lo_
bolos75531373bo_los
bolson8410683bolson
callow114714663callow
cello74919583cello_
cellos84517803cellos
clop86929893__clop
coelom10310433coelom
collar83816173collar
collet84030363collet
collie83621993collie
colloid10312883colloid
colly104926773coll_y
colog86619933co_log
colon78630193co_lon
color76123743co_lor
coop87238653co__op
coplot10518273coplot
cowflop1742893cowflop
cowplop1643363cowplop
dalles74222063dalles
dally95324743dall_y
dalton7311273dalton
dell56938203dell__
dells66630943dell_s
delly96023873dell_y
deploy1237583deploy
develop13145033develop
dewlap1264843dewlap
dialog837973dialog
diglot83014333diglot
dildo71911773dildo_
dildoe8198673dildoe
dildos8179303dildos
dill55239973dill__
dilled84122223dilled
dills65530973dill_s
dilly94923783dill_y
diploe9810153diploe
dobla84913643dobl_a
doblas93812293doblas
doblons1037043doblons
dobro84412213dobro_
dobros93910233dobros
dobson936593dobson
doctor938993doctor
dodo66024913do_do_
dodos75819393do_dos
dogdom1186363dogdom
doggo84410703doggo_
dogleg936323dogleg
dognap1035343dognap
doiled84817293doiled
doily95321033doil_y
dojo126016143do_jo_
dojos135111793do_jos
dol47150653do_l__
dolce85816683do_lce
dolci84912603do_lci
dole56550003do_l_e
doled75430913do_led
doles67843753do_les
doling84923133doling
dollars83311023dollars
dollied93811143dollied
dollies83620983dollies
dolling93817373dolling
dollish11610093dollish
dolloping1344993dolloping
dolma86214173do_lma
dolman95312403dolman
dolmas95213043dolmas
dolmen93911373dolmen
dolors75115313dolors
dolour75710133dolour
dols56943053do_l_s
dolt56649423do_l_t
dolts65626313do_lts
donjon1436463donjon
donor64418193do_nor
doodoo8108893doodoo
doolee73018953doolee
doolie73916833doolie
dooly94821803dool_y
doom76430073do__om
door56928513do__or
doowops1363943doowops
dorp76028053do__rp
doula65717773doul_a
doulas75114993doulas
doyley13487283doyley
doyly124514013doyl_y
droll65415403droll__
drolled93810223drolled
droller84110283droller
drolls75312393droll_s
drolly105411673droll_y
droop85814823d_roop
drop75324403d__rop
drylot1037403drylot
duello756783duello_
duellos845763duellos
dull56430443dull__
dulled84719423dulled
duller74017703duller
dulls64523743dull_s
dully94921633dull_y
duolog835803duolog
fallow124713853fallow
felloe93513923felloe
fellow123712743fellow
fillip11268953fillip
fillo84319783fillo_
fillos94415083fillos
flop96925453__flop
foldup1233813foldup
folio83820883folio_
folios93915463folios
folles93820473folles
follis93113903follis
follows13409923follows
followup1642173followup
folly115022603foll_y
gallon73715813gallon
gallops103211653gallops
galop84716223_galop
glop76724633__glop
golly95121103goll_y
goop75829483go__op
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
hello86522983hello_
hellos95321683hellos
hillo84721653hillo_
hilloa94713033hilloa
hillos94618893hillos
hilltop1244783hilltop
holdup1245183holdup
holla84918493holl_a
hollas94616903hollas
holler93520613holler
holloas103814943holloas
holloed113812753holloed
holloes103818193holloes
holloos104013583holloos
hollows134412333hollows
holly114824433holl_y
holp95727553ho_l_p
hoop96129983ho__op
hullo84417453hullo_
hulloa95011183hulloa
hulloo94511733hulloo
hullos94916293hullos
jalop144212603_jalop
jello126716273jello_
jellos134714283jellos
jolly154517513joll_y
joypop2063133joypop
kolhoz2264773kolhoz
kolkoz1864283kolkoz
kolo87026223ko_lo_
kolos94921213ko_los
loll46128383loll__
lolled74315823lolled
loller63315283loller
lollipop1241883lollipop
lolloped1134463lolloped
lolls512121733loll_s
lolly85120663loll_y
lollypop1551813lollypop
loop67835013__loop
lop58255313___lop
mallow114014743mallow
mellow114112223mellow
moll66735703moll__
mollah11319453mollah
mollie83517103mollie
molls75129783moll_s
molly105222493moll_y
molto75619603molto_
nolo46229313no_lo_
nolos54423353no_los
oleo46630483_oleo_
oleos55419683_oleos
olio46829673_olio_
olios54520853_olios
olla44821173_oll_a
ollas54218283_ollas
orlon5415003_orlon
orlops847303_orlops
oxlip1456883_oxlip
pallor8313673pallor
pillow113110573pillow
plop86625743__plop
polio75722553polio_
polios84019723polios
poll66332133poll__
polled94022003polled
pollee83623273pollee
pollen83416453pollen
poller83921853poller
pollex153711163pollex
pollock1546843pollock
polls74627723poll_s
polo66236633po_lo_
polos76129913po_los
polyol1138713polyol
polyp125611533po_lyp
poop86532813po__op
postop10511943postop
pullup1045893pullup
roll46331653roll__
rolled74220243rolled
roller63919793roller
rollmops1243003rollmops
rollout7811943rollout
rolls55326233roll_s
sallow94315753sallow
saloop84212583saloop
scallop11237643scallop
scollops12235703scollops
shallop12348453shallop
sloop76118913_sloop
slop66533873__slop
soldo67116563soldo_
solion6616383solion
solo45538943so_lo_
solon55026133so_lon
solos54830793so_los
tallol63612223tallol
tallow93714203tallow
toll45535263toll__
tolled73819033tolled
toller63819443toller
tolls54728433toll_s
toluol636903toluol
trollops1044813trollops
trollopy1343273trollopy
volley12419743volley
volvox1933363volvox
wallops123410413wallops
wallow123913513wallow
willow12369693willow
yellow12429883yellow

Search took 7 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.390458182.1
2DLD Change Limit1127162955.53020382.6
3Display Results2952950.0963072.9
 (SQL Overall)1786912956.01629702.6
 
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.