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

164 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
devoured133572(None) 
detoured1036511detoured
devourer1235061devourer
deloused1036972deloused
devoiced15276062devoiced
devolved16325512devolved
devoted124111092devo_ted
devour1076702devour__
devourers1344092devourers
devours1166642devour_s
devouter1235512devouter
favoured1533962favoured
repoured1139562repoured
savoured1234792savoured
arboured1156253arboured
armoured1165223armoured
befouled1434683befouled
berouged1235323berouged
bescoured1444333bescoured
censured11248913censured
cloured103111543_cloured
coloured1148313coloured
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
deterred10137803deterred
detour778193detour__
detours858043detour_s
detoxed1636103deto_xed
detruded1134883detruded
deuced104112123de__uced
devalued1335013devalued
deveined1336673deveined
develed123611933dev_eled
devested13239133devested
deviated13311043deviated
deviled124112183dev_iled
devilled1336743devilled
devised123712563dev_ised
devoice13347343devoice_
devoices14307413devoices
devoid1189363devo__id
devoir1076033devoir__
devoirs1175783devoir_s
devolve14316063devolve_
devolves15286263devolves
devote104513783devo_te_
devotee113811823devo_tee
devotees12286283devotees
devotes113713753devo_tes
devouring1435953devouring
devout10712993devou__t
devoutest1343643devoutest
devoutly1542663devoutly
dewooled1333833dewooled
dewormed15236223dewormed
divorced1544313divorced
dourer74215273d__ourer
doused84821163d__oused
drouked1335543d_rouked
dured75025403d___ured
dyvour1393343dyvour__
dyvours1453183dyvour_s
endeavoured1651413endeavoured
endured93611213_endured
ensured83512943_ensured
enured73315333_e_nured
evoked14457883_evo_ked
evolved14305583_evolved
favored1455983favo_red
favourer1443823favourer
featured1237683featured
fevered14339723fev_ered
flavoured1642973flavoured
floured11289873_floured
gestured1036993gestured
honoured1236313honoured
humoured1444363humoured
inpoured1135813inpoured
laboured1156323laboured
lectured11127223lectured
leisured934763leisured
levered114212303lev_ered
loured74617403__loured
measured1136463measured
meoued9118533me_ou_ed
perdured12287403perdured
perjured18286273perjured
poured95116743__poured
rebored105015883rebo_red
recouped13128663recouped
rehoused1239613rehoused
rerouted9311143rerouted
revered112819333rev_ered
revoiced14317873revoiced
revoked154410523revo_ked
revolted12319863revolted
revolved15328103revolved
revoted114314153revo_ted
rumoured1143783rumoured
savored1158343savo_red
savourer1134473savourer
scoured103811153_scoured
secured1059723se_cured
severed113513863sev_ered
soured74921863__soured
taboured1156273taboured
tenured838363te_nured
textured1695483textured
toured74216153__toured
unsoured9310063unsoured
vapoured1434353vapoured
velured1136683ve_lured
ventured1238273ventured
verdured13255763verdured
vestured1237463vestured

Search took 7 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.406440125.6
2DLD Change Limit1461621646.18623627.9
3Display Results1641640.0762157.9
 (SQL Overall)1786911646.66826798.3
 
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.