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

268 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
holloos10401358(None) 
halloos103716741halloos
holloas103814941holloas
holloes103818191holloes
holloo94415251holloo_
hollos95320631holl_os
hollows134412331hollows
hulloos104010071hulloos
collops112611752collops
dollops10287962dollops
follows13409922follows
halloas104318462halloas
halloes104021522halloes
halloo95118972halloo_
hallos95425102hall_os
hallows134417392hallows
helloes103717472helloes
hellos95321682hell_os
hilloas104413552hilloas
hilloes103815962hilloes
hillos94618892hill_os
hollas94616902holl_as
hollers103818232hollers
hollies103420812hollies
hollo84822162holl_o_
holloa94914822holl_oa
holloed113812752holloed
hollooed12146492hollooed
hollow124212662holl_ow
hoodoos11109292hoodoos
hoopoos1298542hoopoos
hulloas103911912hulloas
hulloes104113922hulloes
hulloo94511732hulloo_
hullos94916292hull_os
lollops9227442lollops
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
apollos946793apoll_os
ballons93916963ballons
balloon93711433balloon
balloons103110523balloons
ballots94116033ballots
bellows124313303bellows
billons93013363billons
billows123611293billows
boleros9310293boleros
bollocks1636503bollocks
bollox1548743boll_ox
bolloxes1736833bolloxes
bolls75531313boll__s
bolos75531373bo_l_os
bolsons969483bolsons
booboos1138143booboos
boocoos1137753boocoos
boohoos1237993boohoos
bookoos1337503bookoos
bullous9311663bullous
callous93516603callous
cellos84517803cell_os
chollas123811353choll_as
cholos114716853cho_l_os
coeloms1139063coeloms
collars93816573collars
collets93517903collets
collies94326583collies
collins93419833collins
colloid10312883colloid
colloids11310173colloids
collop107312313coll_op
cologs96517353co_logs
colons86028683co_lons
colors86622373co_lors
colugos1035693colugos
coplots11511593coplots
doblons1037043doblons
dollars83311023dollars
dollies83620983dollies
dollop9259363doll_op
dolls66126923doll__s
dolors75115313do_lors
doodoos9107623doodoos
fallows133713973fallows
felloes104114383felloes
fellows134212433fellows
fillos94415083fill_os
folios93915463fo_lios
folious103710733folious
folles93820473foll_es
follies103618943follies
follis93113903foll_is
follow124010353foll_ow
gallons83015953gallons
galloon82910643galloon
galloons9289703galloons
galloot82814223galloot
galloots9268963galloots
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
hallahs133912463hallahs
hallels103310133hallels
hallo85127553hall_o_
halloa94918123hall_oa
halloed113314913halloed
hallooed12168773hallooed
hallot95426783hall_ot
halloth134111253halloth
hallow124818323hall_ow
halls85633783hall__s
haloes94623863h_aloes
halons95720713h_alons
halos85230253h_al_os
harlots103413293harlots
helios94816633h_elios
hellbox1944993hellbox
hellers103619833hellers
hellion10311133hellion
hellions11310023hellions
hello86522983hell_o_
helloed113512433helloed
hells85032043hell__s
helos84928063h_el_os
helots95217703h_elots
hillers103718733hillers
hillo84721653hill_o_
hilloa94713033hill_oa
hillock1646693hillock
hillocks1736063hillocks
hilloed113211293hilloed
hills85431353hill__s
hilltop1244783hilltop
hilltops1344933hilltops
hobnobs1443603hobnobs
hoboes114717453ho_boes
hobos106321353ho__bos
holards1148433holards
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
hollooing1385363hollooing
hollowed15157033hollowed
hollower14127403hollower
hollowest1544903hollowest
hollowly1743383hollowly
holly114824433holl__y
holms105117803ho_l_ms
hols76946293ho_l__s
holts85627913ho_l_ts
hommos13128503ho_mmos
homolog1346963homolog
homologs1448243homologs
homos105921793ho__mos
honchos15369573honchos
honors94816793ho_nors
hoodoo10109983hoodoo_
hoods95124083ho__ods
hoofs115721043ho__ofs
hooks125027123ho__oks
hoopoes121212483hoopoes
hoopoo1198753hoopoo_
hoops105621073ho__ops
hoots84830253ho__ots
horrors1078693horrors
hotblood1443673hotblood
hotbloods1543033hotbloods
hotdogs1234453hotdogs
hotfoot1347053hotfoot
hotfoots1444323hotfoots
hotrods1148283hotrods
howlers133312353howlers
howlets13329223howlets
howls116219223howl__s
hoyles12315013hoyl_es
hullers103616263hullers
hullo84417453hull_o_
hulloa95011183hull_oa
hulloed11369793hulloed
hullooed12135093hullooed
hulls84923563hull__s
igloos738033_igloos
jellos134714283jell_os
jollies143516273jollies
kolkhos1364013kolkhos
kolos94921213ko_l_os
koodoos12116393koodoos
lollers72713793lollers
lollies73116923lollies
lollop8238783loll_op
lollopy12234773lollopy
lolls512121733loll__s
loos49051123___loos
mallows123714323mallows
mellows123812233mellows
mollahs12328283mollahs
mollies93420233mollies
molls75129783moll__s
nolos54423353no_l_os
oleos55419683_o_leos
olios54520853_o_lios
ollas54218283_oll_as
orlons6411013_orlons
orlops847303_orlops
ovolos9257203_ovolos
pallors9314363pallors
phyllos1535583phyll_os
pillows122610123pillows
polios84019723po_lios
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
pollock1546843pollock
pollocks1656473pollocks
polls74627723poll__s
polos76129913po_l_os
polyols1238493polyols
rollers73117473rollers
rollmop1142993rollmop
rollmops1243003rollmops
rollout7811943rollout
rollouts8136733rollouts
rolls55326233roll__s
rolltop944043rolltop
sallows103915553sallows
scollops12235703scollops
shalloon1145683shalloon
shalloons1245223shalloons
shallops13288323shallops
shallots11319503shallots
shallows14388863shallows
sholoms1278033sho_loms
solanos74412853solanos
solions7513753solions
solons65120023so_lons
solos54830793so_l_os
tallols73311363tallols
tallows103313743tallows
thallous1136523thallous
tholos94213003tho_l_os
toledos8388863toledos
tollers73217463tollers
tolls54728433toll__s
toluols735823toluols
trollops1044813trollops
villous102810023villous
volleys13316643volleys
voodoos1196343voodoos
wallops123410413wallops
wallows133613533wallows
willows13299753willows
yellows13329603yellows

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272687.47017942.0
3Display Results2682680.0932881.7
 (SQL Overall)1786912687.96922423.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.