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

145 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
taboured115627(None) 
laboured1156331laboured
tabored102810561tabo_red
tabourer1035741tabourer
tabouret1049171tabouret
tamboured1443781tamboured
abjured1735082_abjured
arboured1156252arboured
favoured1533962favoured
harboured1544312harboured
labored102810252labo_red
labourer1045762labourer
savoured1234792savoured
tabered103311592tab_ered
tabooed10267382tabo_oed
taborer9269292tabo_rer
taboret92916112tabo_ret
tabouleh1342792tabouleh
tabour84011322tabour__
tabourers1144672tabourers
tabourets1144162tabourets
tabours94110092tabour_s
tabued94310402tab_u_ed
tambourer1343492tambourer
toured74216152t__oured
vapoured1434352vapoured
abduced1374843_abduced
abhorred1443503_abhorred
abjure1536743_abjure_
abjurer1634753_abjurer
abjures1636523_abjures
abluted10188363_abluted
aboard9312613_aboar_d
aboded104912513_abo_ded
aborted10310423_aborted
abound9239863_abou_nd
abounded1234903_abounded
absurd935903_absur_d
abused95614273_ab_used
adjured1634883_adjured
adored84714243_ado_red
allured8299173_allured
arbored103811603arbo_red
armoured1165223armoured
aroused84914353_aroused
assured858373_assured
augured987193_augured
belaboured1542283belaboured
bored85034303__bo_red
boused95322883__boused
caboched1844043caboched
caboshed1634393caboshed
captured1336573captured
caroused1149263caroused
clamoured1444083clamoured
cloured103111543_cloured
coloured1148313coloured
detoured1036513detoured
devoured1335723devoured
enamoured1243933enamoured
favored1455983favo_red
favourer1443823favourer
flavoured1642983flavoured
floured11289873_floured
glamoured1343203glamoured
hachured1744393hachured
harbored1438643harbo_red
honoured1236313honoured
humoured1444363humoured
inpoured1135813inpoured
jabbered2034433jabbered
laborer9249513labo_rer
labour84210933labour__
labourers1144713labourers
labours9349893labour_s
loured74617403__loured
majored1735853majo_red
manured1039473ma_nured
matured10310043ma_tured
natured838963na_tured
pastured1138233pastured
poured95116743__poured
ragouted1034423ragouted
rancoured1244703rancoured
raptured1155473raptured
razored1736333razo_red
rebored105015883rebo_red
repoured1139563repoured
rumoured1143783rumoured
sabered103213023sab_ered
sabred95916533sab__red
savored1158343savo_red
savourer1134473savourer
scoured103811153_scoured
soured74921863__soured
tabard9313333tab_ar_d
tabarded1234743tabarded
tabaret92717313tab_aret
tabbed114215363tab__bed
tabbied12297793tab_bied
tabbouleh1651543tabbouleh
tabled94020043tab__led
tableted1137533tableted
tabooley1342993tabooley
tabor75518393tabo_r__
taborers10268333tabo_rers
taborets10278063tabo_rets
taborin92210453tabo_rin
tabors84517113tabo_r_s
taboulehs1441973taboulehs
tabouli945843tabou_li
taboulis1045043taboulis
tabouring1245723tabouring
tagboard1245563tagboar_d
tailored936203tailored
taloned8310223talo_ned
tambour1136353tambour__
tamboura1253893tambour_a
tambouras1343493tambouras
tambourers1442743tambourers
tambourin1363623tambourin
tambours1255873tambour_s
tampered13279463tampered
tapered102612933ta_pered
tared69340053ta___red
tarred74720283ta__rred
tattered92011453tattered
tauted75317113ta__uted
teaboard1146293teaboar_d
tenured838363t_enured
textured1695483textured
thiourea1193073thiourea
thoued10429003t_hou_ed
tonsured976383tonsured
tortured935843tortured
tourer64115073t__ourer
toused74122013t__oused
touted74419743t__outed
trouped103910983t_rouped
tutored837553tuto_red
unabjured1942803unabjured
unsoured9310063unsoured
vapored1336923vapo_red
vapourer1344263vapourer
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 Limit1461621457.40619735.6
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.92222556.3
 
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.