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

463 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
harbor1141072(None) 
arbor74818111_arbor
harbors12412411harbors
harbour1247051harbour
arbors84717872_arbors
arbour84211322_arbour
ardor64617862_ardor
armor75118052_armor
barber104419322barber
carbo94923842carbo_
carbon104919042carbon
carbora11310702carbora
carbos105122262carbos
carboy134914182carboy
darbar959952darbar
hagborn1344952hagborn
harbored1438632harbored
harborer1348052harborer
harbours1346902harbours
harder105022402harder
harlot94422802harlot
harmer114719552harmer
harper115018402harper
harrow122610772harrow
hatbox1835132hatbox
havior1248202havior
horror988722horror
labor75117312la_bor
parlor8312672parlor
sartor6313872sartor
tabor75518392ta_bor
abbot9318453_abbot
abhor10411063_abhor
abo59045963_a_bo_
abort76133583_a_bort
abos67734413_a_bos
actor71116073_actor
algor6513053_algor
amber94523213_amber
ambo88225143_ambo_
ambos95321253_ambos
arb510448423_arb__
arbored103811603_arbored
arbores94016033_arbores
arbours93910033_arbours
arbs66834733_arb_s
arco68331543_arco_
ardors74416863_ardors
ardour74110893_ardour
argol65317263_argol
argon65520593_argon
argot67728643_argot
armer76924443_armer
armors85017813_armors
armory114211473_armory
armour84411853_armour
arrow83414883_arrow
arson55118833_arson
arvo76023433_arvo_
arvos86015663_arvos
baboo94319503ba_boo
bailor83412603bailor
balboa10389963balboa
bamboo12310013bamboo
barb85240063barb__
barbal104016663barbal
barbe95328283barb_e
barbed115121313barbed
barbel104317073barbel
barbers114317503barbers
barbes104526233barbes
barbet104427883barbet
barbie105018353barbie
barbs95928193barb_s
barbut104617003barbut
barer74535803bar_er
barhop13319643barhop
barker124822863barker
barlow112911423barlow
baron78131243bar_on
barrow114512763barrow
barter85525373barter
baryon111211613baryon
batboy1387533batboy
burbot10815653burbot
caber95126833ca_ber
cabob114616813ca_bob
camber124418473camber
candor94516423candor
cantor85621523cantor
captor104914603captor
carb85143163carb__
carbarn1139453carbarn
carbons115418943carbons
carboras12311573carboras
carboys144711783carboys
carbs96031463carb_s
carder94524183carder
cardon94120853cardon
career85822243career
carer74942333car_er
cargo85322073cargo_
cargos94619183cargos
carhop133610763carhop
caribou1156993caribou
carob95325223car_ob
carobs104818103carobs
carol75128613car_ol
carom95025563car_om
carper104923633carper
carport11316033carport
carr65434703car__r
carrom10513403carrom
carrot8423123carrot
carter84932273carter
carton84522663carton
cartop104213563cartop
carver114420143carver
castor84418533castor
chador1238663cha_dor
chaebol1444943chaebol
chamber164011053chamber
chantor123710313chantor
charger133914063charger
charier124317903charier
chariot12316213chariot
charmer144913663charmer
charpoy1735713charpoy
charr104821783char__r
charro114212953charro_
charros124312143charros
charter123918303charter
cruor7310443_cruor
curber104517053curber
cursor84110293cursor
dabber114816963dabber
darb76033533darb__
darbars10510093darbars
darbs85323263darb_s
darer65230793dar_er
darker114718693darker
darner74017303darner
darter75320363darter
dauber94112013dauber
durbar968723durbar
earbud936283earbud
earner63617223earner
earworm1238733earworm
error53712233_error
fabber134814113fabber
factor11911453factor
farcer115016083farcer
farebox1943823farebox
farer86733143far_er
farmer115017373farmer
faro76136923far_o_
faros85532023far_os
farrow12309973farrow
favor114712453fa_vor
fervor1235643fervor
forbore12249673forbore
furor8312393fur_or
gabber114916603gabber
gabbro11114953gabbro
gambir11509763gambir
gambol1138223gambol
garb75332673garb__
garbed104815663garbed
garble94118453garble
garbler104012563garbler
garboard1247243garboard
garboil1036513garboil
garbs86321413garb_s
garcon92912483garcon
garner73917003garner
garron73113493garron
garter74420513garter
gator64416033ga_tor
gearbox1742953gearbox
haar77323493ha__ar
habit103027023ha_bit
haboob1377883haboob
habu97325483ha_b_u
habus106317143ha_bus
hacker154822693hacker
hadron102913753hadron
hafter124815883hafter
hagbut1278913hagbut
hagdon1188283hagdon
hailer94720343hailer
hair76330143ha__ir
hairdo1036433hairdo_
hairdos1136823hairdos
hairier103111053hairier
hairwork1845073hairwork
hairworm1644533hairworm
halberd1336043halberd
halbert12314503halbert
haler85033523ha_ler
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
halo76437323ha_lo_
halon86124863ha_lon
halos85230253ha_los
halter94420883halter
hambone1439313hambone
hamburg1544123hamburg
hammer138120033hammer
hamper134518653hamper
hander104526433hander
hangar104114503hangar
hanger104023253hanger
hanker134622093hanker
hansom11219153hansom
hao67251123ha__o_
harass9313943harass
harborage1544653harborage
harborers1446913harborers
harborful1752073harborful
harboring1538263harboring
harborous1445483harborous
harboured1544313harboured
hard85443503har__d
hardboard1645583hardboard
hardboot1446943hardboot
hardcore1446043hardcore
harden105718533harden
hardier114721543hardier
hardly135112833hardly
hards96435653har_ds
hardtop1345053hardtop
hardy125622063har_dy
hare76255733har__e
hared95742183har_ed
hareem114312063hareem
harem104924453har_em
harems115513823harems
hares86255543har_es
haricot12311963haricot
haring104233003haring
hark115237393har__k
harked145422553harked
harken135116343harken
harks126333433har_ks
harl75740003har__l
harlotry1443403harlotry
harlots103413293harlots
harls85634503har_ls
harm95637793har__m
harmed125218833harmed
harmers124116593harmers
harmin113117393harmin
harmony1538173harmony
harms106829013har_ms
harp96134283har__p
harped124418403harped
harpers124916203harpers
harpin113614383harpin
harpoon1238313harpoon
harps105926863har_ps
harpy136418203har_py
harrier104417753harrier
harrower1446363harrower
harrows132611033harrows
harry115322953har_ry
harsh116418053har_sh
harsher13310363harsher
hart76865773har__t
hartal9415473hartal
harts88441593har_ts
hater85034753ha_ter
hatter94724873hatter
hauberk1633463hauberk
hauler95015123hauler
hautboy1553423hautboy
haver115124463ha_ver
haviors1347383haviors
haviour1354823haviour
havoc1337183ha_voc
hawker164812663hawker
hawser125910843hawser
hayer114620243ha_yer
hayfork2043763hayfork
haymow1773683haymow
hazer174820233ha_zer
hazier184712403hazier
hearer94323643hear_er
hector113312653hector
herb94730963herb__
herbal112513493herbal
herbed123513453herbed
herbier1239593herbier
herbs105520503herb_s
herby134715313herb_y
herder104516463herder
hereof123212373hereof
hereon93914363hereon
heriot9422343heriot
heritor10310563heritor
hero74635783her_o_
heron85025503her_on
heros84930863her_os
hirer85423123hir_er
hoarder11329233hoarder
hoarier104211743hoarier
hoarser10388393hoarser
hobber134114633hobber
hobo97026083h_obo_
hobos106321353h_obos
honor85718623h_onor
horrors1078693horrors
hotbox1835693hotbox
humor101110513h_umor
hurler94717223hurler
hurter93915853hurter
jabber173713643jabber
jabot14321513ja_bot
jailor13418573jailor
jargon1448823jargon
jerboa1535633jerboa
juror1239563jur_or
kabar114815553ka_bar
kabob134113933ka_bob
karoo92519583kar_oo
karoos102415803karoos
karroo10410013karroo
labors84016403la_bors
labour84210933la_bour
lamber104418493lamber
larboard1157663larboard
larder73720973larder
lardon74415063lardon
larger74417513larger
largo65319783largo_
largos74815063largos
larker104519243larker
mahzor2035113mahzor
major145212923ma_jor
mambo115215743mambo_
mambos125414493mambos
manor78023923ma_nor
marabou1147493marabou
marble104219103marble
marbler113511673marbler
marbly134111933marbly
marker124420393marker
markhor1635463markhor
marmot10318743marmot
maroon83118203maroon
marrer83716673marrer
marron83717543marron
marrow112812603marrow
martyr1135693martyr
mayor106616623ma_yor
mirror848003mirror
nabber104913543nabber
nabob93913743na_bob
narco76718243narco_
narcos86714203narcos
narrow9269143narrow
orator6314533orator
pallor8313673pallor
parador103311413parador
parboil1138323parboil
pardon94618733pardon
pareo74632603pareo_
pareos87023773pareos
parer75839903par_er
pargo86723723pargo_
pargos95719043pargos
parker124121373parker
parlors9312913parlors
parlour937263parlour
parol74826273par_ol
parr65731153par__r
parrot8320663parrot
parser84822373parser
parson83817903parson
parton84720993parton
parvo107719183parvo_
parvos116614753parvos
pastor84817483pastor
pavior1138533pavior
pawnor11357243pawnor
payor105413843pa_yor
pharaoh1545023pharaoh
pharos11312063phar_os
prior74316173_prior
rancor8810373rancor
raptor83912823raptor
rarer54731703rar_er
rasbora945943rasbora
razor143012603ra_zor
saber75330243sa_ber
sabir75917003sa_bir
sabot7931773sa_bot
sailor63113743sailor
salvor94711093salvor
sambar103914163sambar
sambo95118013sambo_
sambos104315193sambos
sambur10469503sambur
sapor75119253sa_por
sardar73013173sardar
sargo65424413sargo_
sargos74318273sargos
sarod65325873sar_od
saros55238063sar_os
sarsar63011843sarsar
sartors7314953sartors
savior9710173savior
savor85417943sa_vor
sharer95025483shar_er
sharker144313813sharker
sharper124312703sharper
sordor7310213sordor
taber73825823ta_ber
taboo73418093ta_boo
tabors84517093ta_bors
tabour84011313ta_bour
tailor63412503tailor
tambour1136343tambour
tambur10358713tambur
tardo65321103tardo_
taro46846913tar_o_
taroc75721643tar_oc
tarok97921073tar_ok
taros55640823tar_os
tarot55943933tar_ot
tarpon82812803tarpon
tartar63214753tartar
tarter64023563tarter
termor84412513termor
terror63811723terror
torpor839193torpor
turbo71015043turbo_
turbos8910783turbos
turbot8914263turbot
turgor736863turgor
valor83614893va_lor
vapor104013093va_por
varier94619353varier
varoom11411413varoom
warble113516603warble
warbler123211463warbler
warder104020273warder
warier93722893warier
warlord1136293warlord
warmer113816733warmer
warner93717223warner
warper114015583warper
warrior1045363warrior
warwork1757573warwork
warworn1357343warworn
yabber136111833yabber
yarder103813973yarder
yarer84321573yar_er
yarner93313063yarner
yarrow12287933yarrow

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164636.73316740.8
3Display Results4634630.1562967.9
 (SQL Overall)1786914637.02925422.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.