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

437 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
harbors1241241(None) 
arbors84717881_arbors
harbor11410721harbor_
harbours1346921harbours
arbor74818112_arbor_
arbores94016032_arbores
arbours93910042_arbours
ardors74416872_ardors
armors85017812_armors
barbers114317502barbers
carbons115418942carbons
carbora11310702carbora
carboras12311582carboras
carbos105122262carbo_s
carboys144711782carboys
darbars10510092darbars
hagborn1344952hagborn
harbored1438632harbored
harborer1348052harborer
harborers1446912harborers
harborous1445482harborous
harbour1247052harbour
harlots103413292harlots
harmers124116592harmers
harpers124916202harpers
harrows132611032harrows
haviors1347382haviors
horrors1078692horrors
labors84016412la_bors
parlors9312912parlors
sartors7314972sartors
tabors84517112ta_bors
abbots1039283_abbots
abhors11410623_abhors
abort76133583_a_bort
aborts84916183_a_borts
abos67734413_a_bo_s
actors81016763_actors
algors7312553_algors
ambers104519583_ambers
ambos95321253_ambo_s
arbored103811603_arbored
arborist10411613_arborist
arborous1047723_arborous
arbour84211333_arbour
arbs66834733_arb__s
ardor64617863_ardor_
ardours8368883_ardours
argols74514613_argols
argons75018203_argons
argots74116033_argots
armers85520273_armers
armor75118053_armor_
armory114211473_armory
armours9389853_armours
arrows92813483_arrows
arsons63917213_arsons
arvos86015663_arvo_s
baboos103517013ba_boos
bailors93212413bailors
balboas113710073balboas
bamboos1348753bamboos
barbels114514433barbels
barber104419323barber_
barbes104526233barb_es
barbets114915843barbets
barbies114519593barbies
barbs95928193barb__s
barbuts11439843barbuts
barhops14288113barhops
barkers134318513barkers
barlows12259973barlows
barons85025383bar_ons
barrows123411683barrows
barters94223033barters
baryons121010473baryons
batboys1465833batboys
burbots1168673burbots
cabers105023923ca_bers
cabobs124311893ca_bobs
cambers134017443cambers
candors104216763candors
cantors94620753cantors
captors113914983captors
carbarn1139453carbarn
carbarns1238563carbarns
carbo94923843carbo__
carbon104919043carbo_n
carboy134914183carbo_y
carbs96031463carb__s
carders104820353carders
cardons104519933cardons
careers95218783careers
carers85133963car_ers
cargoes104415223cargoes
cargos94619183cargo_s
carhops14329703carhops
caribous1258823caribous
carious93320283carious
carobs104818103car_obs
carols85124983car_ols
caroms105619573car_oms
carpers114521253carpers
carport11316033carport
carports1238943carports
carroms11512403carroms
carrots9714623carrots
carrs75730853car__rs
carters95327253carters
cartons94122473cartons
carvers124817543carvers
castors94919443castors
chadors1338753cha_dors
chaebols1544723chaebols
chambers173410623chambers
chantors133710263chantors
chargers144011323chargers
chariots1339393chariots
charmers154211333charmers
charpoys1834533charpoys
charros124312143charro_s
charrs115219193char__rs
charters134115583charters
cruors838643_cruors
curbers115514383curbers
cursors93910023cursors
dabbers123813213dabbers
darbar959953darbar_
darbies104216983darbies
darbs85323263darb__s
darers75921873dar_ers
darners83815773darners
darters84017603darters
daubers104610423daubers
durbars1077973durbars
earbuds1044633earbuds
earners74016453earners
earworm1238743earworm
earworms1346783earworms
errors63311313_errors
factors12912123factors
farcers124713443farcers
farers95924053far_ers
farmers124315263farmers
faros85532023far_o_s
farrows13259783farrows
favors124211403fa_vors
fervors1336233fervors
forbore12249673forbore
furors9310953fur_ors
gabbers124612833gabbers
gabbros12124653gabbros
gambirs12359083gambirs
gambols1238593gambols
garblers113810283garblers
garbles104016923garbles
garboard1247243garboard
garboards1346363garboards
garboil1036513garboil
garboils1145663garboils
garbs86321413garb__s
garcons102411643garcons
garners83815983garners
garrons82713463garrons
garters84218233garters
gators74115833ga_tors
haars85620473ha__ars
habits113014653ha_bits
haboob1377883ha_boob
haboobs1495463haboobs
habus106317143ha_b_us
hackers164619043hackers
hadrons113314303hadrons
hafters134614333hafters
haftoros1444173haftoros
hagbuts1354933hagbuts
hagdons1258523hagdons
hailers104017263hailers
hairdos1136823hairdo_s
hairs86225173ha__irs
hairwork1845073hairwork
hairworks1944843hairworks
hairworm1644543hairworm
hairworms1743973hairworms
halberd1336053halberd
halberds1435183halberds
halbert12314503halbert
halberts1335973halberts
halers94926913ha_lers
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallows134417393hallows
haloes94623863ha_loes
halons95720713ha_lons
halos85230253ha_lo_s
halters104619803halters
halvers133311423halvers
hambone1439313hambone
hambones1539673hambones
hamburg1544123hamburg
hamburgs1643473hamburgs
hammers144216063hammers
hampers143616953hampers
handers114224333handers
hangars114313493hangars
hangers113120813hangers
hankers144218133hankers
hansoms12238523hansoms
harass9313943har_ass
harborage1544653harborage
harborages1644523harborages
harborful1752073harborful
harborfuls1851323harborfuls
harboring1538263harboring
harborless1542663harborless
harborside1651853harborside
harboured1544313harboured
hardass1139753hardass
hardboard1645583hardboard
hardboards1745163hardboards
hardboot1446943hardboot
hardboots1544353hardboots
hardcore1446043hardcore
hardcores1545973hardcores
hardens113815023hardens
harder105022403harder_
hardies114923233hardies
hards96435653har__ds
hardtops1444843hardtops
hareems12428203hareems
harems115513823har_ems
hares86255543har__es
haricots1347333haricots
harkens144112863harkens
harks126333433har__ks
harlot94422803harlo_t
harlotry1443403harlotry
harls85634503har__ls
harmer114719553harmer_
harmins123716723harmins
harmony1538173harmony
harms106829013har__ms
harness102413933harness
harper115018403harper_
harpies123818313harpies
harpins123615703harpins
harpoon1238313harpoon
harpoons1337483harpoons
harps105926873har__ps
harriers113712433harriers
harries103525493harries
harrow122610773harro_w
harrowers1555683harrowers
harry115322953har__ry
hartals10313023hartals
harts88441593har__ts
hatbox1835133hatbo_x
hatboxes2055003hatboxes
haters94930403ha_ters
hatters104221523hatters
hauberk1633463hauberk
hauberks1742993hauberks
haulers104012443haulers
hautbois1343103hautbois
hautboys1642773hautboys
havers124721483ha_vers
havior1248203havior_
haviours1443843haviours
havocs1435653ha_vocs
hawkers174210333hawkers
hawsers13409483hawsers
hayers124415943ha_yers
hayfork2043763hayfork
hayforks2143423hayforks
haymows1883813haymows
hazers184615953ha_zers
hearers104319783hear_ers
hectors123513263hectors
herbals122710603herbals
herbs105520503herb__s
herders113914123herders
heriots10312063heriots
heritors11310903heritors
heroes94923823her_oes
herons94820543her_ons
heros84930863her_o_s
hirers94518063hir_ers
hoarders12307433hoarders
hobbers143512343hobbers
hoboes114717443h_oboes
hobos106321353h_obo_s
honors94816793h_onors
horror988723horror_
humors11129633h_umors
hurlers103714323hurlers
hurters103413643hurters
jabbers183610583jabbers
jabots1538883ja_bots
jailors14328753jailors
jargons1558203jargons
jerboas1636163jerboas
jurors1338283jur_ors
kabars124513953ka_bars
kabobs14439303ka_bobs
karoos102415803kar_oos
kaross101910013kar_oss
karroos1139313karroos
labor75117313la_bor_
labours9349893la_bours
lambers113817113lambers
larboard1157663larboard
larboards1246983larboards
larders83516943larders
lardons83914493lardons
largos74815063largo_s
larkers113014513larkers
mahzors2135123mahzors
majors154511093ma_jors
mamboes135011823mamboes
mambos125414493mambo_s
manors84420883ma_nors
marabous1249063marabous
marblers12319233marblers
marbles114516653marbles
markers133516103markers
markhors1745393markhors
marmots11311513marmots
maroons92615553maroons
marrers93414313marrers
marrons93216973marrons
marrows122911823marrows
martyrs1234893martyrs
mayors115714193ma_yors
mirrors938623mirrors
nabbers113710463nabbers
nabobs10388213na_bobs
narcos86714203narco_s
narrows10258843narrows
orators7313823orators
pallors9314363pallors
paradors113411903paradors
parboil1138323parboil
parboils1237433parboils
pardons103817623pardons
pareos87023773pareo_s
parers85530743par_ers
pargos95719043pargo_s
parkers133816873parkers
parlor8312673parlor_
parlours1036153parlours
parlous9414293parlous
parols84722613par_ols
parous84024163par_ous
parrots9312743parrots
parrs75928673par__rs
parsers94118153parsers
parsons93516873parsons
partons94620513partons
parvos116614753parvo_s
pastors94119003pastors
paviors1237603paviors
pawnors12297203pawnors
payors114312643pa_yors
pharaohs1644493pharaohs
pharos11312063phar_o_s
priors83914483_priors
rancors9811373rancors
raptors94213353raptors
rasbora945943rasbora
rasboras1045893rasboras
razors154711663ra_zors
sabers85224733sa_bers
sabirs85414633sa_birs
sabots8314703sa_bots
sailors73213723sailors
salvors103910913salvors
sambars115113843sambars
sambos104315193sambo_s
samburs11369343samburs
sapors84118813sa_pors
sarcous9312933sarcous
sardars83112903sardars
sargos74318273sargo_s
sarods74918573sar_ods
saros55238063sar_o_s
sarsars73512143sarsars
sartor6313883sartor_
saviors1058993saviors
savors95616103sa_vors
sharers104720623shar_ers
sharkers154011053sharkers
sharpers133810943sharpers
sordors8310013sordors
tabers84621573ta_bers
taboos83815433ta_boos
tabor75518393ta_bor_
tabours94110093ta_bours
tailors73212393tailors
tambours1255873tambours
tamburs11288613tamburs
tarboosh1343143tarboosh
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar_o_s
tarots66422993tar_ots
tarpons92612213tarpons
tartars73313403tartars
termors94712773termors
terrors73112213terrors
torpors939383torpors
turbos8910783turbo_s
turbots988023turbots
turgors836833turgors
valors93413773va_lors
vapors113812693va_pors
variers103712663variers
various103113103various
varooms1248883varooms
warblers13319103warblers
warbles123215563warbles
warders113416813warders
warhorse1445343warhorse
warlord1136293warlord
warlords1245303warlords
warmers124514293warmers
warners103315563warners
warpers123413583warpers
warriors1135363warriors
warwork1757583warwork
warworks1877063warworks
warworn1357353warworn
yabbers14389353yabbers
yarders113211593yarders
yarners104312203yarners
yarrows13277853yarrows

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 Limit1340274376.64020184.8
3Display Results4374370.1732526.0
 (SQL Overall)1786914377.20324807.9
 
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.