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

121 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
honoured123631(None) 
honored11310121hono_red
honourer1146241honourer
coloured1148312coloured
conjured18117902conjured
contoured1237302contoured
honoree10412112hono_ree
honorer1039672hono_rer
honour94710862honour__
honourers1245572honourers
honours10339382honour_s
humoured1444362humoured
tonsured976382tonsured
arboured1156253arboured
armoured1165223armoured
censured11248913censured
cloured103111543_cloured
coendured1344093coendured
coinsured1245513coinsured
colored10313473colo_red
colourer1037563colourer
concurred1445673concurred
conduced14136963conduced
confused1437033confused
confuted1437683confuted
conjure16109073conjure_
conjurer17117683conjurer
conjures17119913conjures
conquered2145463conquered
consumed1337923consumed
contused1138443contused
detoured1036513detoured
devoured1335723devoured
donnered10307753donnered
endured93611213_endured
ensured83512943_ensured
enured73315333_en_ured
favoured1533963favoured
floured11289873_floured
fondued12466363fondu_ed
hachured1744393hachured
hangared1337573hangared
hankered16289443hankered
harboured1544313harboured
hindered1339453hindered
hobnobbed1651123hobnobbed
hoboed124511683hobo__ed
hocused13167013ho_cused
hollered1237603hollered
homebred16215893homebred
homered133212713ho_mered
honchoed1745733honchoed
hondled123510653hon_dled
honed95332263hon___ed
honeyed1437773hon_eyed
hongied12308163hon_gied
honied104818393hon__ied
honked144517913hon__ked
honor85718623hono_r__
honorand1246333honorand
honorees1148783honorees
honorers1139273hono_rers
honors94816793hono_r_s
honouring1336883honouring
hooded114616743ho_o_ded
hoofed134614893ho_o_fed
hooked145320553ho_o_ked
hooped125518183ho_o_ped
hooted104422663ho_o_ted
hooved134713123ho_o_ved
hoovered15195413hoovered
hothoused1644763hothoused
housed105624103h__oused
hovered143411573ho_vered
humored1336723humo_red
hundred1237143hun_dred
hungered13217053hungered
hunkered16186923hunkered
ignored9226443igno_red
injured15339063_injured
inpoured1135813inpoured
insured83714253_insured
inured73114813_in_ured
jointured17133483jointured
knouted12416773_knouted
laboured1156333laboured
loured74617403__loured
manured1039473man_ured
minored10310103mino_red
mongered1238953mongered
monocled1337113monocled
moored93814173mo_o_red
motored1039933moto_red
odored8399223_odo_red
pondered126411293pondered
postured1139493postured
poured95116743__poured
rancoured1244703rancoured
repoured1139563repoured
rondure837313rondure_
rondures937713rondures
rumoured1143783rumoured
savoured1234793savoured
scoured103811153_scoured
snored74819543_sno_red
snouted84311343_snouted
sojourned1761493sojourned
soured74921863__soured
taboured1156273taboured
tenured838363ten_ured
tongued946323tongu_ed
tonsure758783tonsure_
tonsures869133tonsures
tortured935843tortured
toured74216153__toured
uncured10513233_uncured
unhonored1344413unhono_red
unsoured9310063unsoured
vapoured1434353vapoured
ventured1238273ventured
wondered13239943wondered

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.420425454.8
2DLD Change Limit1461621217.00320871.3
3Display Results1211210.0602016.7
 (SQL Overall)1786911217.48323879.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.