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

171 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
detoured103651(None) 
devoured1335721devoured
deloused1036972deloused
deterred10137802deterred
detour778192detour__
detours858042detour_s
detoxed1636102deto_xed
detruded1134882detruded
devourer1235062devourer
repoured1139562repoured
toured74216152__toured
arboured1156253arboured
armoured1165223armoured
befouled1434683befouled
berouged1235323berouged
bescoured1444333bescoured
bettered113011833bettered
censured11248913censured
clotured11246163clotured
cloured103111543_cloured
coloured1148313coloured
contoured1237303contoured
deaired9411533de_aired
debarred12165633debarred
deboned113411633debo_ned
debouched18123633debouched
debuted11379333de_buted
declared1248743declared
decocted1437683decocted
decoded123212383deco_ded
decolored1345663decolored
decoloured1443083decoloured
decoupled15114283decoupled
decoyed14358333deco_yed
decurved1534843de_curved
deduced1266683de_duced
deferred13106363deferred
defoamed15356243defoamed
defocused16143533defocused
defogged1533783defogged
deforced15247373deforced
deformed15248263deformed
defused125211093de_fused
defuzed21447043de_fuzed
dehorned1345683dehorned
dehorted1357303dehorted
delouse839833delouse_
delouser936363delouser
delouses9310013delouses
deluded10158763de_luded
deluged10167413de_luged
demobbed1643203demobbed
demoded123611123demo_ded
demoed103713443demo__ed
demoted114313543demo_ted
demounted1344903demounted
demure9311533de_mure_
demurer1037873de_murer
demurred1234933demurred
denatured1146023denatured
denoted93512763deno_ted
denounced1344033denounced
denture8311893denture_
dentures9312453dentures
denuded10167663de_nuded
deplored1237233deplored
deplumed1434083deplumed
deponed113712873depo_ned
deported1249703deported
deposed113412023depo_sed
deputed114610173de_puted
desired9311983de_sired
desorbed1236443desorbed
detached1537733detached
detailed10319873detailed
detained103111643detained
detected12289733detected
deterged11127923deterged
deterrer9137013deterrer
detested10279623detested
deticked1635693deticked
detonated1138213detonated
detouring1136973detouring
detoxes1538803deto_xes
detrude936083detrude_
detrudes1036203detrudes
deuced104112123de__uced
devoiced15276063devoiced
devolved16325513devolved
devoted124111093devo_ted
devour1076703devour__
devourers1344093devourers
devours1166643devour_s
devouter1235513devouter
dewooled1333833dewooled
dewormed15236223dewormed
dithered13189293dithered
doctored1245613docto_red
dourer74215273d__ourer
doused84821163d__oused
drouked1335543d_rouked
dured75025403d___ured
endured93611213_endured
ensured83512943_ensured
enured73315333_e_nured
favoured1533963favoured
featured1237683featured
fettered12259493fettered
floured11289873_floured
gestured1036993gestured
gettered10258613gettered
hectored1436873hecto_red
honoured1236313honoured
humoured1444363humoured
inpoured1135813inpoured
laboured1156323laboured
lectured11127223lectured
leisured934763leisured
lettered92910783lettered
loured74617403__loured
matured10310033mat_ured
measured1136463measured
mentored1138003mento_red
meoued9118533me_ou_ed
metered103514013met_ered
metred95315143met__red
motored1039933moto_red
natured838963nat_ured
outpoured1246013outpoured
perdured12287403perdured
perjured18286273perjured
petered103314973pet_ered
poured95116743__poured
rebored105015883rebo_red
recouped13128663recouped
rehoused1239613rehoused
rerouted9311143rerouted
restored96417193resto_red
retired84620143ret_ired
retooled938473retooled
retore67630773reto_re_
retorted9312333retorted
retouched1545113retouched
retuned86613973ret_uned
returned9459133ret_urned
rumoured1143783rumoured
savoured1234793savoured
scoured103811153_scoured
sectored1138063secto_red
secured1059723se_cured
soured74921863__soured
stored75524213_sto_red
stoure64814943_stoure_
stoures74614163_stoures
sutured8310373sut_ured
taboured1156273taboured
tenured838363te_nured
tethered1238493tethered
textured1695483textured
tourer64115073__tourer
toused74122013__toused
touted74419743__touted
tutored837553tuto_red
unsoured9310063unsoured
vapoured1434353vapoured
vectored1435623vecto_red
velured1136683ve_lured
ventured1238273ventured
verdured13255763verdured
vestured1237463vestured
vetoed10359823veto__ed

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.436409841.7
2DLD Change Limit1461621716.50022486.5
3Display Results1711710.0632714.3
 (SQL Overall)1786911716.99925530.9
 
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.