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

296 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
hollows13441233(None) 
follows13409921follows
hallows134417391hallows
holloas103814941holloas
holloes103818191holloes
holloos104013581holloos
hollos95320631hollo_s
hollow124212661hollow_
allows94517682_allows
bellows124313302bellows
billows123611292billows
collops112611752collops
dollops10287962dollops
fallows133713972fallows
fellows134212432fellows
follow124010352follow_
gallows113513512gallows
halloas104318462halloas
halloes104021522halloes
halloos103716742halloos
hallos95425102hallo_s
hallow124818322hallow_
helloes103717462helloes
hellos95321682hello_s
hilloas104413552hilloas
hilloes103815962hilloes
hillos94618892hillo_s
hollas94616902holl_as
hollers103818232hollers
hollies103420812hollies
hollo84822162hollo__
holloa94914822hollo_a
holloed113812752holloed
holloo94415252hollo_o
hollowed15157022hollowed
hollower14127392hollower
hollowest1544902hollowest
hollowly1743382hollowly
hulloas103911912hulloas
hulloes104113922hulloes
hulloos104010072hulloos
hullos94916292hullo_s
lollops9227442lollops
mallows123714322mallows
mellows123812232mellows
pillows122610122pillows
sallows103915552sallows
shallows14388862shallows
tallows103313742tallows
wallows133613532wallows
willows13299752willows
yellows13329602yellows
allods73615083_allods
allots64019173_allots
allow85420663_allow_
alloys94014563_alloys
apollos946793apollo_s
ballons93916963ballons
ballots94116033ballots
barlows12259973barlows
bellow114213353bellow_
belows114614183_belows
billons93013363billons
billow114111223billow_
billowy15366903billowy
blows105423833__blows
bollocks1636503bollocks
bollox1548743bollo_x
bolloxes1736833bolloxes
bolls75531313boll__s
bolos75531373bo_lo_s
bolsons969483bolsons
borrows12349253borrows
bowwows1454123bowwows
bullous9311663bullous
callous93516603callous
callow114714663callow_
cellos84517803cello_s
chollas123811353choll_as
cholos114716853cho_lo_s
coeloms1139063coeloms
collars93816573collars
collets93517903collets
collies94326583collies
collins93419833collins
colloid10312883colloid
colloids11310173colloids
collop107312313collo_p
cologs96517353co_logs
colons86028683co_lons
colors86622373co_lors
coplots11511593coplots
doblons1037043doblons
dollars83311023dollars
dollies83620983dollies
dollop9259363dollo_p
dolls66126923doll__s
dolors75115313do_lors
elbows1196713_elbows
fallow124713853fallow_
felloes104114383felloes
fellow123712743fellow_
fillos94415083fillo_s
flows115822363__flows
fogbows1643853fogbows
folios93915463folio_s
folious103710733folious
folles93820473foll_es
follies103618943follies
follis93113903foll_is
followed15146273followed
follower14137073follower
followers15146183followers
followup1642173followup
followups1742293followups
gallons83015953gallons
gallops103211653gallops
gallous82813953gallous
glows95518033__glows
hallahs133912463hallahs
hallels103310133hallels
hallo85127553hallo__
halloa94918123hallo_a
halloed113314913halloed
halloo95118973hallo_o
hallot95426783hallo_t
halloth134111253halloth
hallowed15179493hallowed
hallower14139813hallower
hallowers15137723hallowers
halls85633783hall__s
haloes94623863h_aloes
halons95720713h_alons
halos85230253h_alo_s
harlots103413293harlots
harrows132611033harrows
haymows1883813haymows
helios94816633helio_s
hellers103619833hellers
hellions11310023hellions
hello86522983hello__
helloed113512423helloed
hells85032043hell__s
helos84928063h_elo_s
helots95217703h_elots
hillers103718733hillers
hillo84721653hillo__
hilloa94713033hillo_a
hillock1646693hillock
hillocks1736063hillocks
hilloed113211293hilloed
hills85431353hill__s
hilltops1344933hilltops
hobnobs1443603hobnobs
hoboes114717443ho_boes
hobos106321353ho_bo_s
hoedown14125753hoedown
hoedowns15124653hoedowns
holards1148433holards
holddown1642903holddown
holddowns1742353holddowns
holders113715903holders
holdout11510903holdout
holdouts1245493holdouts
holds94623243ho_l_ds
holdups1333593holdups
holeless1189363holeless
holes84748653ho_l_es
holies94630033ho_lies
holisms123811113holisms
holists104413963holists
holks124720563ho_l_ks
holla84918493holl__a
hollaed11359853hollaed
holland11349473holland
hollands12247273hollands
holler93520613holl_er
holloaed12157393holloaed
holloing12148823holloing
hollooed12146493hollooed
holloware1543943holloware
hollowares1643763hollowares
hollowing1675933hollowing
hollowness1642543hollowness
holly114824433holl__y
holms105117803ho_l_ms
hols76946293ho_l__s
holts85627913ho_l_ts
hommos13128503hommo_s
homologs1448233homologs
homos105921783ho_mo_s
honors94816793ho_nors
hoodoos11109293hoodoos
hoods95124083ho__ods
hoofs115721043ho__ofs
hooks125027123ho__oks
hoopoes121212483hoopoes
hoopoos1298543hoopoos
hoops105621073ho__ops
hoosgows1542913hoosgows
hoots84830253ho__ots
horrors1078693horrors
hotdogs1234453hotdogs
hotrods1148283hotrods
howlers133312353howlers
howlets13329223howlets
howls116219223howl__s
hows106345603h___ows
hoyles12315013hoyl_es
hullers103616263hullers
hullo84417453hullo__
hulloa95011183hullo_a
hulloed11369793hulloed
hulloo94511733hullo_o
hulls84923563hull__s
inflows1335523inflows
jellos134714283jello_s
jollies143516273jollies
kolos94921213ko_lo_s
kotows13446523ko_tows
kowtows1742763kowtows
lollers72713793lollers
lollies73116923lollies
lollop8238783lollo_p
lollopy12234773lollopy
lolls512121733loll__s
lows75843013___lows
mallow114014743mallow_
mellow114112223mellow_
mollahs12328283mollahs
mollies93420233mollies
molls75129783moll__s
morrows12318723morrows
nolos54423353no_lo_s
oleos55419683_oleo_s
olios54520853_olio_s
ollas54218283_oll_as
orlons6411013_orlons
orlops847303_orlops
oxbows1833713_oxbows
pallors9314363pallors
phyllos1535583phyllo_s
pillow113110573pillow_
pillowy15316423pillowy
plows105419903__plows
polios84019723polio_s
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
pollock1546843pollock
pollocks1656473pollocks
polls74627723poll__s
polos76129913po_lo_s
polyols1238493polyols
powwows1442853powwows
reflows13258983reflows
reglows11288843reglows
replows12329703replows
rollers73117473rollers
rollmops1243003rollmops
rollout7811943rollout
rollouts8136733rollouts
rolls55326233roll__s
sallow94315753sallow_
sallowy13369343sallowy
scollops12235703scollops
shallops13288323shallops
shallots11319503shallots
shallow13388873shallow_
sholoms1278033sho_loms
slows85323463__slows
solions7513753solions
solons65120023so_lons
solos54830793so_lo_s
sorrows10278403sorrows
swallows14295893swallows
tallols73311363tallols
tallow93714203tallow_
tallowy13347633tallowy
thallous1136523thallous
tholos94213003tho_lo_s
tollers73217463tollers
tolls54728433toll__s
toluols735823toluols
trollops1044813trollops
unhallows15122123unhallows
upflows1543513upflows
villous102810023villous
volleys13316643volleys
wallops123410413wallops
wallow123913513wallow_
whitlows1743083whitlows
willow12369693willow_
willowy16276353willowy
yellow12429883yellow_
yellowy16255693yellowy

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.390458182.1
2DLD Change Limit1340272966.62320236.6
3Display Results2962960.1102690.9
 (SQL Overall)1786912967.12325086.5
 
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.