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

225 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
devours116664(None) 
detours858041detours
devoirs1175781devoirs
devour1076701devour_
dyvours1453181dyvours
bevors111610342bevo_rs
decors94017772deco_rs
demurs939772de_murs
detour778192detour_
devious1138522deviou_s
devoir1076032devoir_
devons104512252devo_ns
devotes113713752devotes
devoured1335722devoured
devourer1235062devourer
devourers1344092devourers
devout10712992devou_t
dolours8438822dolours
dyvour1393342dyvour_
favours13437092favours
fervours1453052fervours
repours9310232repours
savours10389342savours
tenours72610072tenours
velours10278082velours
amours83512663_amours
arbours93910043arbours
ardours8368883ardours
armours9389853armours
befouls1236053befouls
bescours1245093bescours
bevor101510813bevo_r_
bezoars1836793bezoars
cerous85821203cerou_s
clours85215093_clours
colours95913443colours
deairs74013783de_airs
dealers84118613dealers
dears65736883de__ars
debars94218043de_bars
deboners11268113deboners
debones103315113debones
debouch15124253debouch
debtors1038533debtors
debugs10467823de_bugs
debuts93911753de_buts
deckers144413833deckers
decocts1237833decocts
decoders122810413decoders
decodes113914983decodes
decolors1187713decolors
decolours1274413decolours
decor84717573deco_r_
decorum1246943decorum
decorums1344993decorums
decos85522123deco__s
decoyers14287713decoyers
decoys123911283deco_ys
decury1277963de_cury
deers64930523de__ers
defers105116943de_fers
defiers113913993defiers
defoams1336193defoams
defocus1335283defocus
defogs1156683defo_gs
deform1259613defo_rm
deforms1337803deforms
degauss933923degauss
degums10438623de_gums
dehorn10439653deho_rn
dehorns11428363dehorns
dehort104618103deho_rt
dehorts11379773dehorts
deicers103612733deicers
delouse839833delouse
delousers1044663delousers
delouses9310013delouses
delvers113411993delvers
demobs11429483demo_bs
demons94917723demo_ns
demos86022993demo__s
demoses103815823demoses
demotes104717673demotes
demount1049743demount
demounts1135473demounts
demur8311163de_mur_
demure9311533de_mure
denars74621433de_nars
dengues938183dengues
deniers84515183deniers
denotes83817003denotes
denture8311893denture
dentures9312453dentures
deodars937623deodars
depones103717093depones
deport94922393depo_rt
deports105012883deports
deposers11359243deposers
deposes103117213deposes
depots94716343depo_ts
desorb95210203deso_rb
desorbs10437713desorbs
deters74724683de_ters
detoured1036513detoured
detoxes1538803detoxes
devalues1235853devalues
devas96218883dev__as
deveins1138803deveins
devels104313903dev_els
devests114410473devests
devices133212583devices
devilry1433973devilry
devils104412813dev_ils
devisers12339863devisers
devises114116763devises
devisors12347253devisors
devoice13347343devoice
devoices14307413devoices
devoid1189363devo_id
devolve14316063devolve
devolves15286263devolves
devon95113683devo__n
devote104513783devo_te
devoted124111093devoted
devotee113811823devotee
devotees12286283devotees
devouring1435953devouring
devouter1235513devouter
devoutest1343643devoutest
devoutly1542663devoutly
devs86424033dev___s
dewars105117073de_wars
dewools1145593dewools
deworm1249523dewo_rm
deworms1338023deworms
dimouts1037893dimouts
diseurs839403diseurs
divers105024963div_ers
divots104712203divo_ts
doers65225713d__oers
dolors75115313dolo_rs
dolour75710133dolour_
donors75115793dono_rs
doors65022133d__oors
dorrs65520593d__orrs
dors56747603d__o_rs
doums85417643d__oums
dour56330433d__our_
doura66518663d__oura
douras75016723d__ouras
drouks1137123d_rouks
drovers115212643drovers
dugouts935043dugouts
endeavours1451773endeavours
evokers14386793_evokers
evokes13459683_evokes
favors124211403favo_rs
favour12438333favour_
femurs1136713fe_murs
fervors1336233fervo_rs
fervour1343103fervour_
fetors91014473feto_rs
fevers125414893fev_ers
flavours1434693flavours
flours94414053_flours
fours85521493__fours
giaours834573giaours
haviours1443843haviours
honours10339373honours
hours85422393__hours
humours1286433humours
inpours936423inpours
labours9349893labours
lemurs837253le_murs
levers94621323lev_ers
leviers103510343leviers
lours55125293__lours
memoirs1136803memoirs
meous76120063me_ou_s
nervous1037143nervou_s
nevus84611393nev_u_s
odours7418253_odours
ours47237563___ours
paviours1343613paviours
pelorus939273pelorus
pours74623183__pours
recoups1188843recoups
recourse1038383recourse
recurs83315803re_curs
redouts81411663redouts
repour8310993repour_
revers94529633rev_ers
revokers15366753revokers
revokes144212503revokes
revolts1038893revolts
revotes104716393revotes
revues9813903rev_ues
rigours8207003rigours
rumours976373rumours
sapours93610623sapours
saviours1154273saviours
savors95616103savo_rs
savour94110703savour_
savoury13365873savoury
scours84913593_scours
senors63620783seno_rs
serous65023563serou_s
setous64917373setou_s
setouts74110333setouts
severs94121123sev_ers
sours55230503__sours
stours65015633_stours
tabours94110093tabours
tenors63217753teno_rs
tenour62610733tenour_
tours55325893__tours
tumours976753tumours
uveous936603uveou_s
valours10248743valours
vapours12277463vapours
velour9328763velour_
venous93713193venou_s
vetoers10359473vetoers
vigours11285483vigours
yours85217883__yours

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272256.84619577.4
3Display Results2252250.0762960.5
 (SQL Overall)1786912257.06225303.2
 
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.