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

155 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
harbored143863(None) 
arbored103811601_arbored
harborer1348051harborer
harboured1544311harboured
arbores94016032_arbores
arboured1156252_arboured
armored102610472_armored
barbered13259542barbered
carboyed1637182carboyed
hamboned1637002hamboned
harbor11410722harbor__
harborers1446912harborers
harbors12412412harbor_s
harrowed1556262harrowed
labored102810242la_bored
tabored102810562ta_bored
aboded104912513_a_boded
aborted10310423_a_borted
adored84714243_a_dored
arbor74818113_arbor__
arboreal1045633_arboreal
arboreta1045223_arboreta
arborized2166973_arborized
arbors84717883_arbor_s
armorer9259913_armorer
armoured1165223_armoured
arrowed1148113_arrowed
barbed115121313barb__ed
bareboned1445103bareboned
barred95725793bar__red
bartered113113013bartered
bored85034303___bored
cambered15129003cambered
carbora11310703carbor_a
carboras12311583carboras
carburet12411113carburet
careered1139493careered
caroled103717693car_oled
caromed123713623car_omed
carromed1338563carromed
cartoned111312833cartoned
chambered19145993chambered
charioted1595863charioted
charred134614483char__red
chartered15158393chartered
factored1436213factored
farrowed1545283farrowed
favored1455983fa_vored
forboded15215353forboded
forbore12249673forbore_
gamboled1435873gamboled
garbed104815663garb__ed
garbled114512803garb_led
garboard1247243garboard
garnered10247113garnered
garoted9710133gar_oted
garred85217403gar__red
garroted1056783garroted
gartered10319583gartered
habited1337883ha_bited
hachured1744393hachured
hagborn1344953hagbor_n
haired105117173ha__ired
halberd1336053halber_d
halloaed121510153halloaed
halloed113314913hallo_ed
hallooed12168773hallooed
hallowed15179493hallowed
haloed104717603ha_lo_ed
haltered123112553haltered
hambone1439313hambone_
hambones1539673hambones
hammered16218853hammered
hampered16239933hampered
hangared1337573hangared
hankered16289443hankered
harassed1237113harassed
harborage1544653harborage
harborages1644523harborages
harborful1752073harborful
harboring1538263harboring
harborless1542663harborless
harborous1445483harborous
harborside1651853harborside
harbour1247053harbo_ur
harbours1346923harbours
hardboard1645583hardboard
hardbound1643413hardbound
hardcore1446043hardcore_
hardcores1545973hardcores
hardened1338613hardened
hardwired1742873hardwired
hared95742183ha___red
harked145422553har__ked
harkened1637483harkened
harmed125218833har__med
harped124418403har__ped
harpooned1544323harpooned
harried113815533har_ried
harrower1446363harrower
hatboxes2055003hatboxes
hatred104814333ha__tred
havered144011453ha_vered
hectored1436873hectored
herbaged1554523herbaged
herbed123513453herb__ed
hoboed124511683h_obo_ed
honored11310123h_onored
humored1336723h_umored
jabbered2034433jabbered
jamboree1944863jamboree
jargoned1735233jargoned
jarred144613253jar__red
jawboned21133553jawboned
laborer9249503la_borer
laboured1156323la_boured
larboard1157663larboard
majored1735853ma_jored
mamboed14417623mambo_ed
marbled123212113marb_led
marooned1138563marooned
marred95421043mar__red
marrowed1445973marrowed
martyred1434283martyred
mirrored1145773mirrored
narrowed1235203narrowed
parbaked1735503parbaked
parboiled1445223parboiled
pardoned12189333pardoned
paroled104217633par_oled
parred95024073par__red
parroted1158843parroted
pastored1139963pastored
rancored1137223rancored
rawboned14114253rawboned
razored1736333ra_zored
rebored105015883_rebored
sabered103213023sa_bered
sabred95916533sa_b_red
savored1158343sa_vored
tabered103311593ta_bered
tabooed10267383ta_booed
taborer9269293ta_borer
taboret92916113ta_boret
taboured1156273ta_boured
tailored936203tailored
tamboured1443783tamboured
tarred74720283tar__red
unarmored1244873unarmored
vapored1336923va_pored
varoomed1445293varoomed
warbled133212163warb_led
warlord1136293warlor_d
warred104019843war__red
yabbered1633963yabbered

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621556.59322169.3
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.10925135.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.