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

141 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
laboured115632(None) 
labored102810241labo_red
labourer1045751labourer
taboured1156271taboured
abjured1735072_abjured
arboured1156252arboured
belaboured1542272belaboured
clamoured1444062clamoured
favoured1533962favoured
flavoured1642972flavoured
glamoured1343182glamoured
harboured1544312harboured
laborer9249502labo_rer
labour84210932labour__
labourers1144712labourers
labours9349882labour_s
loured74617402l__oured
savoured1234792savoured
tabored102810562tabo_red
tabourer1035742tabourer
tabouret1049172tabouret
tamboured1443782tamboured
vapoured1434352vapoured
abduced1374843_abduced
abhorred1443493_abhorred
abjure1536733_abjure_
abjurer1634743_abjurer
abjures1636513_abjures
abluted10188363_abluted
aboard9312613_aboar_d
aboded104912513_abo_ded
aborted10310423_aborted
abound9239863_abou_nd
abounded1234903_abounded
absurd935903_absur_d
abused95614273_ab_used
adjured1634873_adjured
adored84714233_ado_red
allured8299173_allured
arbored103811603arbo_red
armoured1165223armoured
aroused84914343_aroused
assured858373_assured
augured987193_augured
belabored1443813belabo_red
blabbered13184593blabbered
bored85034303__bo_red
boused95322883__boused
caboched1844043caboched
caboshed1634393caboshed
captured1336563captured
caroused1149253caroused
clabbered16184753clabbered
clamored1336943clamo_red
clangoured1441623clangoured
cloured103111543_cloured
coloured1148303coloured
detoured1036513detoured
devoured1335723devoured
enamoured1243933enamoured
favored1455983favo_red
favourer1443823favourer
flavored1554573flavo_red
floured11289873_floured
hachured1744393hachured
harbored1438633harbo_red
honoured1236313honoured
humoured1444363humoured
inpoured1135813inpoured
jabbered2034433jabbered
laagered1055853laagered
labeled102510563lab_eled
labelled11278293labelled
labiated11109303labiated
labor75117313labo_r__
laboredly1542383labo_redly
laborers10208383labo_rers
labors84016403labo_r_s
labouring1236213labouring
labret8320223lab__ret
lackered15108673lackered
lacquered2143363lacquered
laddered1136743laddered
lagered92311153la_gered
laired75216813la__ired
lapboard1355783lapboar_d
lappered13288213lappered
larboard1157663larboar_d
larruped1142863larruped
lathered121512323lathered
lauded83812153la__uded
laurel649033la__urel
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
lectured11127223lectured
leisured934763leisured
liquored1842883liquored
louped95316383l__ouped
loused74822913l__oused
louted74920693l__outed
louvred11354663l__ouvred
lured65427493l___ured
majored1735853majo_red
manured1039473ma_nured
matured10310033ma_tured
natured838963na_tured
pastured1138233pastured
poured95116743__poured
ragouted1034423ragouted
rancoured1244693rancoured
raptured1155463raptured
razored1736333razo_red
rebored105015883rebo_red
repoured1139563repoured
rumoured1143783rumoured
sabered103213023sab_ered
sabred95916533sab__red
savored1158343savo_red
savourer1134473savourer
scoured103811153_scoured
slabbered14165083slabbered
soured74921863__soured
tabered103311593tab_ered
tabooed10267383tabo_oed
taborer9269293tabo_rer
taboret92916113tabo_ret
tabouleh1342793tabouleh
tabour84011313tabour__
tabourers1144673tabourers
tabourets1144163tabourets
tabours94110073tabour_s
tabued94310403tab_u_ed
tambourer1343493tambourer
toured74216153__toured
unabjured1942793unabjured
unlabored1243803unlabo_red
unsoured9310053unsoured
vapored1336923vapo_red
vapourer1344263vapourer
yabbered1633963yabbered

Search took 10 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.326548131.9
2DLD Change Limit1461621419.34315644.0
3Display Results1411410.0632238.1
 (SQL Overall)1786911419.73218361.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.