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

238 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
devour107670(None) 
detour778191detour
devoir1076031devoir
devours1166641devours
devout10712991devout
dyvour1393341dyvour
bevor101510812bevo_r
decor84717572deco_r
demur8311162de_mur
detours858042detours
devious1138522devious
devoid1189362devoid
devoirs1175782devoirs
devon95113682devo_n
devons104512252devons
devote104513782devote
devoured1335722devoured
devourer1235062devourer
devouter1235512devouter
dolour75710132dolour
dour56330432d__our
dyvours1453182dyvours
favour12438332favour
fervour1343102fervour
repour8310992repour
savour94110702savour
tenour62610732tenour
velour9328762velour
amour75014853_amour
arbour84211333arbour
ardour74110903ardour
armour84411853armour
befoul1137253befoul
bescour1145203bescour
bevors111610343bevors
bezoar1736913bezoar
cerous85821203cerous
clour76617283_clour
colour85915093colour
deader84220473deader
deafer104114813deafer
deair65817193de_air
dealer74122143dealer
dear55343603de__ar
dearer74822803dearer
debar85517863de_bar
debone93714783debone
deboner103110483deboner
debouch15124253debouch
debtor938333debtor
debug94210063de_bug
debut86024143de_but
decker135215993decker
deco76125973deco__
decoct11313783decoct
decode104414743decode
decoder113712293decoder
decolor1087033decolor
decolour1185013decolour
decors94017773decors
decorum1246943decorum
decos85522123deco_s
decoy115716313deco_y
decoyer13348683decoyer
decoys123911283decoys
decury1277963de_cury
deeper93613503deeper
deer56739023de__er
defer94619753de_fer
deffer134411303deffer
defier105118653defier
defoam1238563defoam
defocus1335283defocus
defog1048523defo_g
defogs1156683defogs
deform1259623deform
defter104215923defter
degum94711903de_gum
dehorn10439653dehorn
dehort104618103dehort
deicer94114413deicer
delouse839833delouse
delouser936363delouser
delver104913493delver
demo77427553demo__
demob104913503demo_b
demobs11429483demobs
demode104013463demode
demoed103713443demoed
demon86520313demo_n
demons94917723demons
demos86022993demo_s
demote94817803demote
demount1049743demount
demure9311533de_mure
demurs939773de_murs
denar65223293de_nar
dengue838253dengue
denier74420693denier
denote74118043denote
denser74115193denser
denture8311893denture
deodar837713deodar
deoxy1648883de_oxy
depone93616553depone
deport94922393deport
depose94215763depose
deposer104011843deposer
depot85727923depo_t
depots94716343depots
desorb95210203desorb
desoxy1744623desoxy
deter65028043de_ter
detoured1036513detoured
detox13310953deto_x
dev76033773dev___
deva85720983dev__a
devalue1136013devalue
devas96218883dev_as
devein1039143devein
devel94217123dev_el
devels104313903devels
devest104418703devest
device124512163device
devil94714733dev_il
devilry1433973devilry
devils104412813devils
devise104215753devise
deviser114212393deviser
devisor11357043devisor
devoice13347343devoice
devolve14316063devolve
devoted124111093devoted
devotee113811823devotee
devotes113713753devotes
devourers1344093devourers
devouring1435953devouring
devoutly1542663devoutly
devs86424033dev__s
dewar95817733de_war
dewier104013463dewier
dewool1047403dewool
deworm1249533deworm
dexter143810893dexter
dimout9414243dimout
diseur738843diseur
diver94827803div_er
divot95723073divo_t
divots104712203divots
doer57734703d__oer
dolor67617963dolo_r
dolours8438823dolours
donor64418193dono_r
door56928513d__oor
dor47253923d__o_r
dorr56627723d__orr
doum76226673d__oum
doura66518663d__oura
doux125817983d__oux
drouk1039433d_rouk
drover104614593drover
dugout8310363dugout
endeavour1351973endeavour
ever77027693_ev_er
evoke12478853_evoke
evoker13467913_evoker
favor114712453favo_r
favours13437093favours
femur1038683fe_mur
fervor1235643fervo_r
fervours1453053fervours
fetor81214533feto_r
fever115617953fev_er
flavour1334633flavour
flour84916453_flour
four76226863__four
giaour735363giaour
haviour1354823haviour
honour94710863honour
hour75827313__hour
humour11116753humour
indevout1254963indevout
inpour837063inpour
labour84210933labour
lemur739773le_mur
lever85125163lev_er
levier94013873levier
levo76820063levo__
lour45430683__lour
memoir1037213memoir
meou65325863me_ou_
meous76120063me_ous
nervous1037143nervous
never86218643nev_er
nevoid1098793nevoid
nevus84611393nev_us
odour64710493_odour
our36042893___our
paviour1244623paviour
pour611527473__pour
recoup10810373recoup
recur74116843re_cur
redout71820253redout
repours9310233repours
revoke135216243revoke
revoker14419193revoker
revolt9316223revolt
revote94917453revote
revue81114453rev_ue
rigour7258023rigour
rumour8127383rumour
sapour83812373sapour
saviour1035213saviour
savor85417943savo_r
savours10389343savours
savoury13365873savoury
scour75315533_scour
senor53822803seno_r
serous65023563serous
setous64917373setous
setout64719463setout
sever85426053sev_er
sour45935893__sour
stour54916743_stour
tabour84011323tabour
tenor53620253teno_r
tenours72610073tenours
tour45530383__tour
tumour8137403tumour
undevout1246083undevout
uveous936603uveous
valour93010373valour
vapour11378873vapour
velours10278083velours
venous93713193venous
vetoer93410063vetoer
vigour10256803vigour
your78623433__your

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162384.86023192.6
3Display Results2382380.0802975.0
 (SQL Overall)1786912385.31333632.8
 
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.