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

221 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
defrays143611(None) 
defrags1236191defrags
defray1337641defray_
derays105514251de_rays
affrays1644062affrays
betrays12127822betrays
bewrays15145112bewrays
decays124612912de_cays
deejays1843432deejays
defats105114552def_ats
defeats113511232defeats
defoams1336192defoams
defrag1136462defra_g
defraud1243912defraud
defrauds1343242defrauds
defrayal1542612defrayal
defrayals1642282defrayals
defrayed1635402defrayed
defrayer1534932defrayer
defrayers1644172defrayers
delays104014052de_lays
derats74625062de_rats
deray95024182de_ray_
drays95819772d__rays
frays116920102__frays
orfrays1343532orfrays
affray1534973affray_
arrays95311683_arrays
beflags1355493beflags
befrets1237613befrets
belays114313853be_lays
bendays13327513bendays
betray111511443betray_
bewraps14135403bewraps
bewray14147733bewray_
brays106723113__brays
days87637133d___ays
deads75726913de__ads
deals65435343de__als
deans66131393de__ans
dearies83526273dearies
dearly104615323dearly_
dears65736883de__ars
dearths11498843dearths
deary95826843dear_y_
debags104211063de_bags
debarks14388493debarks
debars94218043de_bars
debeaks1436103debeaks
debris93311493debr_is
decafs124010883de_cafs
decals93717713de_cals
decares102818533decares
decay114718483de_cay_
declass1038733declass
declaws1336253declaws
decoys123911283de_coys
decrees102513123decrees
decrials1137133decrials
decries103319803decries
decry115514353decr_y_
dedans85915073de_dans
deejay1734523deejay_
deers64930523deer__s
deewans11306903deewans
deface123113863def_ace
defaces133213403defaces
defame123212433def_ame
defames132812253defames
defang1137753def_ang
defangs1235363defangs
defat95426693def_a_t
defeat103817163defea_t
defects134511523defects
defends12358773defends
deferrals1343683deferrals
defers105116943def_ers
defiant11311923defiant
defiers113913993defiers
defies104624053def_ies
defiles114016843defiles
defines114118683defines
defis96717503def__is
deflate113613943deflate
deflates123013943deflates
defleas1147223defleas
defoam1238563defoa_m
defocus1335283defocus
defogs1156683def_ogs
deforces14248403deforces
deforms1337803deforms
defraying1735853defraying
defrock1744643defrock
defrocks1844113defrocks
defrost1139553defrost
defrosts1244833defrosts
deftly1336533deftly_
defuels11296983defuels
defunds12376753defunds
defuses114814593defuses
defuzes20398303defuzes
defy114921263def__y_
degas75119163de_ga_s
degrade10229903degrade
degrades11269923degrades
degrees92810723degrees
dekares122710873dekares
delay94820633de_lay_
deleads9379703deleads
deltas74414823delta_s
demarks14339233demarks
demeans1039713demeans
denars74621433de_nars
denary105316863denary_
denials84114133denials
dentals83915393dentals
deodars937623deodars
departs104310683departs
deploys1336523deploys
deprave1337073deprave
depraves1436873depraves
depress10239873depress
derail74218813de_rail
derails84216393de_rails
derat65044083de_ra_t
derate74531233de_rate
derates84028893de_rates
derby114715343de_rby_
dermas94116813de_rmas
dermis94717163de_rmis
derms85022893de_r_ms
derries83124623derries
derris73615273de_rris
derry94721373de_rry_
desmans1039003desmans
destroys1236693destroys
detract101414633detract
detracts11138833detracts
detrain8412253detrain
detrains9411763detrains
devas96218883de_va_s
dewans105215143de_wans
dewars105117073de_wars
dewlaps1334663dewlaps
dextrans1695983dextrans
deys85027473de___ys
dirams94413703d_irams
dismays13237433dismays
dobras94811913dobra_s
doorways1544043doorways
dourahs11487253dourahs
douras75016723doura_s
drabs85119673d__rabs
drags75521113d__rags
drams86025833d__rams
drats66628373d__rats
draws95119373d__raws
dray85428093d__ray_
drys86314803d__r_ys
duras65727723d_ura_s
durras74713373durra_s
embays131408333_embays
eras45441503_e_ra_s
essays965653_essays
estrays10529403estrays
eyras84715923_eyra_s
fays108535363__f_ays
ferals94216643fe_rals
flays116321053__flays
forays124813003_forays
frags96322163__frags
fraps105620553__fraps
frass85321123__frass
frats86829673__frats
fray105428903__fray_
gerahs1039413ge_rahs
grays95621333__grays
hearsays1444513hearsays
henrys12366103henr_ys
heydays1734143heydays
hoorays13418373hoorays
hurrays13386153hurrays
jetways2094053jetways
keyways2043373keyways
leeways1354453leeways
morays114613883_morays
ofays11488923_of_ays
orfray1234393orfray_
prays105022433__prays
rays77642353___rays
redbays1336013redbays
redraws11218473redraws
reflags1156953reflags
refract121311603refract
refracts13137383refracts
refrain10310043refrain
refrains1139593refrains
reframe1239393reframe
reframes1338993reframes
refries104419733refries
refry114412463refr_y_
relays94316753re_lays
repays113813973re_pays
replays12399763replays
resays93714153re_says
resprays1344713resprays
rewraps12136563rewraps
seaways13307513seaways
seracs84418573se_racs
serais64326133se_rais
sprays115913643_sprays
strays96417933_strays
sunrays1037083sunrays
terais64023513te_rais
terras63516973terra_s
tetrads82910193tetrads
tetras63017623tetra_s
trays85623433__trays
veejays2042313veejays
zebras1737853zebra_s
zebrass1834113zebrass

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272216.64320175.7
3Display Results2212210.0603683.3
 (SQL Overall)1786912216.85626063.4
 
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.