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

269 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
devout1071299(None) 
devour1076701devour
debut86024142de_but
decoct11313782decoct
dehort104618102dehort
demount1049742demount
deport94922392deport
depot85727922depo_t
detour778192detour
devest104418702devest
devious1138522devious
devoid1189362devoid
devoir1076032devoir
devon95113682devo_n
devons104512252devons
devote104513782devote
devours1166642devours
devouter1235512devouter
devoutly1542662devoutly
dimout9414242dimout
divot95723072divo_t
dugout8310362dugout
dyvour1393342dyvour
indevout1254962indevout
redout71820252redout
revolt9316222revolt
setout64719462setout
undevout1246082undevout
about75229083_about
abvolt11169833abvolt
beaut75135213be_aut
befoul1137253befoul
begot84625953bego_t
beshout12311833beshout
besmut10310653besmut
besot76429713beso_t
bevomit1445353bevomit
bevor101510813bevo_r
bevors111610343bevors
bout66353293__bout
bugout9311863bugout
buyout11310103buyout
cavort11316173cavort
cerous85821203cerous
clout75330463_clout
copout10418783copout
cutout8315923cutout
dacoit9415453dacoit
dakoit11310353dakoit
daut56443563d__aut
davit93424593dav_it
dealt65234283de_alt
debit85727853de_bit
debone93714783debone
debouch15124253debouch
debt77139023de__bt
debug94210063de_bug
debuts93911753de_buts
decant93524223decant
deceit93018213deceit
decent94023703decent
deco76125973deco__
decocts1237833decocts
decode104414743decode
decor84717573deco_r
decors94017773decors
decorum1246943decorum
decos85522123deco_s
decoy115716313deco_y
decoys123911283decoys
deduct10610793deduct
deet57356583de__et
defat95426693de_fat
default1147893default
defeat103817163defeat
defect124816173defect
defoam1238563defoam
defocus1335283defocus
defog1048523defo_g
defogs1156683defogs
deform1259623deform
defrost1139553defrost
deft85540223de__ft
degum94711903de_gum
degust8310253degust
dehorn10439653dehorn
dehorts11379773dehorts
deist64633593de_ist
deject164512843deject
delft95623323de_lft
delict94320333delict
delist74625053delist
delouse839833delouse
delt57855273de__lt
demast9517063demast
dement93825143dement
demit84832303de_mit
demivolt1454573demivolt
demo77427553demo__
demob104913503demo_b
demobs11429483demobs
demode104013463demode
demoed103713443demoed
demon86520313demo_n
demons94917723demons
demos86022993demo_s
demote94817803demote
demounts1135473demounts
demur8311163de_mur
dengue838253dengue
denote74118043denote
dent57158413de__nt
deoxy1648883de_oxy
depart94720563depart
depict113514793depict
depone93616553depone
deports105012883deports
depose94215763depose
deposit10313003deposit
depots94716343depots
depute94512303de_pute
deputy12426713de_puty
derat65044083de_rat
desalt7518313desalt
desert72725493desert
desist74818813desist
desorb95210203desorb
desoxy1744623desoxy
despot93413293despot
detect94217403detect
detent73624483detent
detest74122843detest
detours858043detours
detox13310953deto_x
dev76033773dev___
deva85720983dev__a
devalue1136013devalue
devas96218883dev_as
devein1039143devein
devel94217123dev_el
devels104313903devels
devests114410473devests
deviant11311313deviant
deviate11312713deviate
device124512163device
devil94714733dev_il
devils104412813devils
devise104215753devise
devoice13347343devoice
devoirs1175783devoirs
devolve14316063devolve
devoted124111093devoted
devotee113811823devotee
devotes113713753devotes
devoured1335723devoured
devourer1235063devourer
devoutest1343643devoutest
devs86424033dev__s
dewool1047403dewool
deworm1249533deworm
dicot85429093dico_t
dimouts1037893dimouts
divert103922813divert
divest106820073divest
divots104712203divots
doat56947673d__oat
doit56347853d__oit
dolour75710133dolour
dolt56649423d__olt
donut6324513d_onut
dost57248353d__ost
dot47573183d__o_t
doubt8720093d__oubt
doum76226673d__oum
dour56330433d__our
doux125817983d__oux
droit65127123d_roit
dropout10410003dropout
dropt86924433d_ropt
drouk1039433d_rouk
drouth104410103d_routh
dugouts935043dugouts
duvet9321873duv_et
dyvours1453183dyvours
eelpout947783eelpout
event85924443_event
evert84929513_evert
evict104417143_evict
evoke12478853_evoke
evolute1045683_evolute
fadeout11410193fade_out
favour12438333favour
fervour1343103fervour
flout86226203_flout
gavot9321123gavo_t
gemot84024233gemo_t
glout65925813_glout
gout56646003__gout
grout65330423_grout
helot85332683helo_t
hideout1179793hide_out
knout95018263_knout
layout9513703layout
levant9314493levant
levo76820063levo__
lout45952143__lout
mahout11415803mahout
meou65325863me_ou_
meous76120063me_ous
nervous1037143nervous
nevoid1098793nevoid
nevus84611393nev_us
out38072153___out
payout11714653payout
peanut8318183peanut
pigout9314613pigout
pivot106523873pivo_t
pout65752553__pout
putout8315113putout
qiviut1846613qiviut
ragout7317183ragout
readout8615513readout
reboot84119333reboot
rebut75927383re_but
recoat84024273recoat
recount9315173recount
recoup10810373recoup
recut74729243re_cut
redoubt10167843redoubt
redouts81411663redouts
remount9512283remount
report85326023report
repot75132623repo_t
repour8310993repour
reroute7313963reroute
resort65728623resort
retort66831153retort
revert93529113revert
revest94623603revest
revet84938843rev_et
revoke135216243revoke
revolts1038893revolts
revolute1176793revolute
revote94917453revote
revue81114453rev_ue
rout46153283__rout
rubout8313563rubout
runout6414873runout
savour94110703savour
scout75031453_scout
sellout7313583sellout
serous65023563serous
setous64917373setous
setouts74110333setouts
shout85433173_shout
snout54530633_snout
spout75029633_spout
sprout8419403sprout
stout57434053_stout
tenour62610733tenour
tout46753823__tout
trout57332573_trout
tryout9410753tryout
uveous936603uveous
velour9328763velour
veloute1037733veloute
venous93713193venous
volt76439533__volt
wideout1179033wide_out

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.393454684.5
2DLD Change Limit1127162695.46620621.3
3Display Results2692690.0932892.5
 (SQL Overall)1786912695.95230022.0
 
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.