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

251 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
lollop823878(None) 
collop107312311collop
dollop9259361dollop
lollops9227441lollops
lollopy12234771lollopy
bollox1548742bollox
collops112611752collops
dollops10287962dollops
follow124010352follow
gallop93311382gallop
hollo84822162hollo_
holloa94914822holloa
holloo94415252holloo
hollos95320632hollos
hollow124212662hollow
loll46128382loll__
lolled74315822lolled
loller63315282loller
lollipop1241882lollipop
lolloped1134462lolloped
lolls512121732loll_s
lolly85120662loll_y
lollypop1551812lollypop
loop67835012lo__op
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
doblon938013doblon
doll56632493doll__
dollar74110983dollar
dolled83518073dolled
dolloped1234983dolloped
dolls66126923doll_s
dolly96125203doll_y
dolor67617963do_lor
doowop1283853doowop
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
lall45531313lall__
lallan63414183lallan
lalled74218753lalled
lalls55324133lall_s
laptop1076813laptop
lilo46731563l_ilo_
lilos55821873l_ilos
lobo67229863lo_bo_
lobos75921843lo_bos
lockup1434763lockup
loco67030743lo_co_
locos75822603lo_cos
logion76013723logion
logo57931763lo_go_
logoi69715943lo_goi
logon615922313lo_gon
logos67225333lo_gos
lollers72713793lollers
lollies73116923lollies
lolling83415783lolling
lollipops1341783lollipops
lolloping1244693lolloping
lollypops1651953lollypops
loo38359823lo__o_
loof78141053lo__of
look87333473lo__ok
lookup1233453lookup
loom67035053lo__om
loon47344793lo__on
loops75723963lo__ops
loopy105316643lo__opy
loos49051123lo__os
loot46955823lo__ot
lop58255313___lop
lotion65716523lotion
lotos54724633lo_tos
lotto55217573lotto_
lottos64613103lottos
loup66028433lo__up
lowboy1435903lowboy
lowly114113333lowl_y
lull44225763lull__
lulled74516443lulled
luller63415483luller
lulls54119653lull_s
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 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162517.64014753.4
3Display Results2512510.0763302.6
 (SQL Overall)1786912518.09222082.4
 
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.