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

124 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
harbour124705(None) 
arbour84211331_arbour
harbor11410721harbo_r
harbours1346921harbours
arbor74818112_arbo_r
arbours93910042_arbours
ardour74110902_ardour
armour84411852_armour
harborer1348052harborer
harbors12412412harbors
harboured1544312harboured
haviour1354822haviour
labour84210932la_bour
parlour937262parlour
tabour84011322ta_bour
tambour1136352tambour
about75229083_a_bout
amour75014853_a_mour
arbors84717883_arbors
arboured1156253_arboured
ardor64617863_ardo_r
ardours8368883_ardours
armor75118053_armo_r
armours9389853_armours
armoury12376233_armoury
barber104419323barb_er
barbut104617003barb_ut
candour104210243candour
carbo94923843carbo__
carbon104919043carbo_n
carbons115418943carbons
carbora11310703carbora
carbos105122263carbo_s
carboy134914183carbo_y
carboys144711783carboys
caribou1156993caribou_
caribous1258823caribous
carious93320283carious
chabouk1844543cha_bouk
darbar959953darb_ar
earbud936283earb_ud
faitour1034883faitour
farceur12525273farceur
faubourg1461693faubourg
favour12438333fa_vour
fervour1343103fervour
garbler104012563garbler
garboard1247243garboard
garboil1036513garboil
haboob1377883ha_boob
habu97325483ha_b_u_
habus106317143ha_b_us
hagborn1344953hagborn
hagbut1278923hagb_ut
hambone1439313hambone
hamburg1544123hamb_urg
handout11314103handout
hangout11411393hangout
harbored1438633harbored
harborers1446913harborers
harborful1752073harborful
harborous1445483harborous
harbouring1643603harbouring
hardboard1645583hardboard
hardboot1446943hardboot
hardbound1643413hardbound
hardcourt1544043hardcourt
harder105022403har_der
hardier114721543hardier
harlot94422803harlo_t
harlotry1443403harlotry
harlots103413293harlots
harmer114719553har_mer
harmful1535763harmful
harmony1538173harmony
harper115018403har_per
harpoon1238313harpoon
harrier104417753harrier
harrow122610773harro_w
harrower1446363harrower
harrows132611033harrows
harsher13310363harsher
hatbox1835133hatbo_x
hauteur1033893hauteur
havior1248203havio_r
haviours1443843haviours
herbier1239593herbier
honour94710863h_onour
horror988723horro_r
hour75827313h___our
humour11116753h_umour
labor75117313la_bo_r
labours9349893la_bours
larboard1157663larboard
marabou1147493marabou_
marabous1249063marabous
marabout1249103marabout
marbler113511673marbler
pandour10408213pandour
paramour1246083paramour
parboil1138323parboil
parlor8312673parlo_r
parlours1036153parlours
parlous9414293parlous
parous84024163par_ous
paviour1244623paviour
rancour987133rancour
sambhur1453083sambhur
sambur10469503samb_ur
santour737373santour
sapour83812373sa_pour
sarcous9312933sarcous
sartor6313883sarto_r
saviour1035213saviour
savour94110703sa_vour
tabor75518393ta_bo_r
tabours94110093ta_bours
tamboura1253893tamboura
tambours1255873tambours
tambur10358713tamb_ur
valour93010373va_lour
vapour11378873va_pour
various103113103various
warbler123211463warbler

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.423422437.4
2DLD Change Limit1340271247.15318737.2
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.62223444.1
 
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.