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

118 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
harbours134692(None) 
arbours93910041_arbours
harbors12412411harbo_rs
harbour1247051harbour_
arbors84717882_arbo_rs
arbour84211332_arbour_
ardours8368882_ardours
armours9389852_armours
harbor11410722harbo_r_
harborers1446912harborers
harboured1544312harboured
haviours1443842haviours
labours9349892la_bours
parlours1036152parlours
tabours94110092ta_bours
tambours1255872tambours
amours83512663_a_mours
arbor74818113_arbo_r_
arbores94016033_arbores
arboured1156253_arboured
ardors74416873_ardo_rs
ardour74110903_ardour_
armors85017813_armo_rs
armour84411853_armour_
armoury12376233_armoury
barbers114317503barb_ers
barbuts11439843barb_uts
candours11408643candours
carbons115418943carbo_ns
carbora11310703carbo_ra
carboras12311583carboras
carbos105122263carbo__s
carboys144711783carbo_ys
caribous1258823caribou_s
carious93320283cariou_s
chabouks1943823cha_bouks
darbars10510093darb_ars
earbuds1044633earb_uds
faitours1134263faitours
farceurs13464723farceurs
faubourg1461693faubourg
faubourgs1541233faubourgs
favours13437093fa_vours
fervours1453053fervours
garblers113810283garblers
garboard1247243garboard
garboards1346363garboards
garboils1145663garboils
haboobs1495463ha_boobs
habus106317143ha_b_u_s
hagborn1344953hagbo_rn
hagbuts1354933hagb_uts
hambones1539673hambones
hamburg1544123hamb_urg
hamburgs1643473hamb_urgs
handouts1238233handouts
hangouts1236183hangouts
harbored1438633harbored
harborer1348053harborer
harborfuls1851323harborfuls
harborous1445483harborous
harbouring1643603harbouring
hardboard1645583hardboard
hardboards1745163hardboards
hardboots1544353hardboots
hardbound1643413hardbound
hardbounds1742663hardbounds
hardcourt1544043hardcourt
harlotry1443403harlotry
harlots103413293harlo_ts
harmers124116593har_mers
harpers124916203har_pers
harpoons1337483harpoons
harriers113712433harriers
harrowers1555683harrowers
harrows132611033harro_ws
hatboxes2055003hatboxes
hauteurs1133733hauteurs
haviors1347383havio_rs
haviour1354823haviour_
honours10339373h_onours
horrors1078693horro_rs
hours85422393h___ours
humours1286433h_umours
labors84016413la_bo_rs
labour84210933la_bour_
larboard1157663larboard
larboards1246983larboards
marabous1249063marabou_s
marabouts1364963marabouts
marblers12319233marblers
pandours11317993pandours
paramours1345653paramours
parboils1237433parboils
parlors9312913parlo_rs
parlour937263parlour_
parlous9414293parlou_s
parous84024163par_ou_s
paviours1343613paviours
rancours1076713rancours
sambhurs1543183sambhurs
samburs11369343samb_urs
santours837183santours
sapours93610623sa_pours
sarcous9312933sarcou_s
sartors7314963sarto_rs
saviours1154273saviours
savours10389343sa_vours
tabors84517113ta_bo_rs
tabour84011323ta_bour_
tambour1136353tambour_
tamboura1253893tamboura
tambouras1343493tambouras
tamburs11288613tamb_urs
valours10248743va_lours
vapours12277463va_pours
various103113103variou_s
warblers13319103warblers

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.1561145455.1
2DLD Change Limit1461621187.26620115.9
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.46823927.6
 
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.