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

206 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
defrags123619(None) 
defrag1136461defrag_
defrays1436111defrays
beflags1355492beflags
debags104211062de_bags
defangs1235362defangs
defats105114552def_ats
defeats113511232defeats
defoams1336192defoams
defogs1156682def_ogs
defraud1243912defraud
defrauds1343242defrauds
defray1337642defra_y
derats74625062de_rats
derays105514252de_rays
drags75521112d__rags
frags96322172__frags
reflags1156952reflags
affrays1644063affrays
bedrugs11194283bedrugs
beflag1265883beflag_
befogs1246453bef_ogs
befrets1237613befrets
bergs84718043be_r_gs
betrays12127823betrays
bewraps14135403bewraps
bewrays15145113bewrays
brags85625103__brags
crags85622573__crags
dags66642603d___ags
deads75726913de__ads
deals65435343de__als
deans66131393de__ans
dearies83526273dearies
dears65736883de__ars
dearths11498843dearths
debag94212303de_bag_
debarks14388493debarks
debars94218043de_bars
debeaks1436103debeaks
debris93311493debr_is
debugs10467823de_bugs
decafs124010883de_cafs
decals93717713de_cals
decares102818533decares
decays124612913de_cays
declass1038733declass
declaws1336253declaws
decrees102513123decrees
decrials1137133decrials
decries103319803decries
dedans85915073de_dans
deejays1843433deejays
deers64930523deer__s
deewans11306903deewans
deface123113863def_ace
defaces133213403defaces
defame123212433def_ame
defames132812253defames
defang1137753def_ang
defat95426693def_a_t
defeat103817163defea_t
defects134511523defects
defends12358773defends
deferrals1343683deferrals
defers105116943def_ers
defiant11311923defiant
defiers113913993defiers
defies104624053def_ies
defiles114016843defiles
defines114118683defines
defis96717503def__is
deflate113613943deflate
deflates123013943deflates
defleas1147223defleas
defoam1238563defoa_m
defocus1335283defocus
defog1048523def_og_
deforces14248403deforces
deforms1337803deforms
defragged1643043defragged
defragger1542603defragger
defraggers1642013defraggers
defrayal1542613defrayal
defrayals1642283defrayals
defrayed1635403defrayed
defrayer1534933defrayer
defrayers1644173defrayers
defrock1744643defrock
defrocks1844113defrocks
defrost1139553defrost
defrosts1244833defrosts
defuels11296983defuels
defunds12376753defunds
defuses114814593defuses
defuzes20398303defuzes
degage92711383de_gage
degas75119163de_ga_s
degrade10229903degrade
degrades11269923degrades
degrees92810723degrees
dekares122710873dekares
delays104014053de_lays
deleads9379703deleads
deltas74414823delta_s
demarks14339233demarks
demeans1039723demeans
denars74621433de_nars
denials84114133denials
dentals83915393dentals
deodars937623deodars
departs104310683departs
deprave1337073deprave
depraves1436873depraves
depress10239873depress
deraign936573de_raign
deraigns1034883de_raigns
derail74218813de_rail
derails84216393de_rails
derange939813de_range
deranges1039973de_ranges
derat65044083de_ra_t
derate74531233de_rate
derates84028893de_rates
deray95024183de_ra_y
dermas94116813de_rmas
dermis94717163de_rmis
derms85022893de_r_ms
derries83124623derries
derris73615273de_rris
desmans1039003desmans
detract101414633detract
detracts11138833detracts
detrain8412253detrain
detrains9411763detrains
devas96218883de_va_s
dewans105215143de_wans
dewars105117073de_wars
dewlaps1334663dewlaps
dextrans1695983dextrans
dirams94413703d_irams
dishrags1346203dishrags
dobras94811913dobra_s
dourahs11487253dourahs
douras75016723doura_s
drabs85119673d__rabs
drag64825053d__rag_
drams86025833d__rams
drats66628373d__rats
draws95119373d__raws
drays95819773d__rays
dregs76114863d__regs
drugs75214653d__rugs
duras65727733d_ura_s
durras74713373durra_s
dustrags1044943dustrags
enrage72715073_enrage
enrages83114853_enrages
eras45441503_e_ra_s
ergs55523813_e_r_gs
eyras84715923_eyra_s
fags86939123__f_ags
ferals94216643fe_rals
flags95321283__flags
frag85126273__frag_
fraps105620553__fraps
frass85321123__frass
frats86829673__frats
frays116920103__frays
frigs96019273__frigs
frogs96220773__frogs
frugs96114283__frugs
gerahs1039413ge_rahs
jetlags1533863jetlags
orfrays1343533orfrays
peags86122843pe__ags
peerage1089803peerage
peerages1189893peerages
rags55448373___rags
redraws11218473redraws
reflag1098083reflag_
refract121311603refract
refracts13137383refracts
refrain10310043refrain
refrains1139593refrains
reframe1239393reframe
reframes1338993reframes
refries104419733refries
rerigs74014793re_rigs
retags73414303re_tags
rewraps12136563rewraps
scrags95713803_scrags
seabags1037483seabags
seracs84418573se_racs
serais64326133se_rais
serfage1138403serfage
serfages1238233serfages
sprags95715823_sprags
tagrags936123tagrags
teargas837013teargas
terais64023513te_rais
terras63516973terra_s
tetrads82910193tetrads
tetras63017623tetra_s
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.423422437.4
2DLD Change Limit1340272065.92322628.2
3Display Results2062060.1101872.7
 (SQL Overall)1786912066.45627678.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.