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 “harboured” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

48 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
harboured154431(None) 
arboured1156251_arboured
harbored1438641harbo_red
arbored103811602_arbo_red
armoured1165222_armoured
harborer1348062harbo_rer
harbour1247052harbour__
harbours1346922harbour_s
laboured1156332la_boured
taboured1156272ta_boured
tamboured1443782tamboured
abjured1735083_a_bjured
arbores94016033_arbo_res
arbour84211333_arbour__
arbours93910043_arbour_s
armored102610473_armo_red
armourer1054883_armourer
aroused84914353_ar_oused
barbered13259553barb_ered
carboyed1637183carbo_yed
carburet12411113carb_uret
caroused1149263car_oused
favoured1533963fa_voured
garboard1247243garboar_d
hachured1744393ha_chured
hamboned1637003hambo_ned
harbor11410723harbo_r__
harborers1446913harbo_rers
harbors12412413harbo_r_s
harbouring1643603harbouring
hardboard1645583hardboar_d
hardbound1643413hardbou_nd
hardwired1742873hardwired
harpooned1544323harpooned
harrowed1556283harro_wed
honoured1236313h_onoured
humoured1444363h_umoured
labored102810253la_bo_red
labourer1045763la_bourer
larboard1157663larboar_d
parboiled1445223parboiled
rancoured1244703rancoured
savoured1234793sa_voured
tabored102810563ta_bo_red
tabourer1035743ta_bourer
tabouret1049173ta_bouret
tambourer1343493tambourer
vapoured1434353va_poured

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 Filter1786911486410.420425454.8
2DLD Change Limit148641486.83021763.0
3Display Results48480.0133692.3
 (SQL Overall)178691487.26324602.9
 
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.