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

232 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
defrag113646(None) 
defrags1236191defrags
defray1337641defray
beflag1265882beflag
debag94212302de_bag
defang1137752defang
defat95426692def_at
defeat103817162defeat
defoam1238562defoam
defog1048522def_og
defraud1243912defraud
defrays1436112defrays
derat65044082de_rat
deray95024182de_ray
drag64825052d__rag
frag85126272__frag
reflag1098082reflag
affray1534973affray
bedrug10164953bedrug
beflags1355493beflags
befog1159013bef_og
befret11315963befret
berg75425543be_r_g
betray111511443betray
bewrap13157053bewrap
bewray14147733bewray
brag75229723__brag
crag75625303__crag
dag57753013d___ag
dead65434243de__ad
deaf85838403de__af
deal56347413de__al
dean56039483de__an
dear55343603de__ar
dearer74822803dearer
dearie73319813dearie
dearly104615323dearly
dears65736883dear_s
dearth104212513dearth
deary95826843dear_y
debags104211063de_bags
debar85517863de_bar
debark134210943debark
debars94218043debars
debeak1336763debeak
debris93311493debris
debug94210063de_bug
decaf114919443de_caf
decal85523233de_cal
decare93919153decare
decay114718483de_cay
declaw1266703declaw
decree93117783decree
decrial10310323decrial
decry115514353decr_y
dedal75719023de_dal
deejay1734523deejay
deer56739023deer__
deers64930523deer_s
deewan10267553deewan
def76546723def___
deface123113863deface
defame123212433defame
defangs1235363defangs
defats105114553defats
defeats113511233defeats
defect124816173defect
defend113910493defend
defer94619753def_er
deferral1244353deferral
defers105116943defers
deffer134411303deffer
defi86321493def__i
defiant11311923defiant
defied115016383defied
defier105118653defier
defies104624053defies
defile105216663defile
define104718143define
defis96717503def_is
deflate113613943deflate
deflea1037443deflea
defleas1147223defleas
defoams1336193defoams
defogs1156683defogs
deforce13267243deforce
deform1259623deform
deforms1337803deforms
defragged1643043defragged
defragger1542603defragger
defrauds1343243defrauds
defrayal1542613defrayal
defrayed1635403defrayed
defrayer1534933defrayer
defraying1735853defraying
defrock1744643defrock
defrost1139553defrost
deft85540223def__t
defter104215923defter
deftly1336533deftly
defuel10348933defuel
defund11447983defund
defuse105712723defuse
defuze19487843defuze
defy114921263def__y
defying15328823defying
degage92711383de_gage
degas75119163de_gas
degrade10229903degrade
degree82814853degree
dekare112811563dekare
deking125614553deking
delay94820633de_lay
delead84112343delead
delta66117773delta_
deltas74414823deltas
demark134211023demark
demean9510563demean
denar65223293de_nar
denari710917353denari
denars74621433denars
denary105316863denary
denial74720513denial
dental74319173dental
deodar837713deodar
depart94720563depart
deprave1337073deprave
deraign936573de_raign
derail74218813de_rail
derange939813de_range
derate74531233de_rate
derats74625063de_rats
derays105514253de_rays
derby114715343de_rby
dere56845903de_r_e
derm76031893de_r_m
derma84918513de_rma
dermal93614343dermal
dermas94116813dermas
derms85022893de_rms
derris73615273derris
derry94721373de_rry
desman9311693desman
detract101414633detract
detrain8412253detrain
deva85720983de_va_
devas96218883de_vas
dewan95718043de_wan
dewar95817733de_war
dewars105117073dewars
dewax165510853de_wax
dewing114115703dewing
dewlap1264843dewlap
dextral1577003dextral
dextran1586163dextran
diram84419473d_iram
dishrag1246273dishrag
dobra85013103dobra_
dobras94811913dobras
doura66518663doura_
dourah10479813dourah
douras75016723douras
drab76226453d__rab
drags75521113d__rags
dram75832003d__ram
drat56247833d__rat
draw85623013d__raw
dray85428093d__ray
dreg66821653d__reg
drug65718133d__rug
dura55232113d_ura_
dural64923893d_ural
duras65727733d_uras
durra65315793durra_
durras74713373durras
dustrag945363dustrag
enrage72715073_enrage
era35741503_e_ra_
eras45441503_e_ras
erg45531073_e_r_g
eyra76217553_eyra_
eyras84715923_eyras
fag76852363__f_ag
feral85424653fe_ral
flag87427083__flag
frae75330473__frae
frags96322173__frags
frap95925813__frap
frat75648543__frat
fray105428903__fray
frig85424503__frig
frog85624363__frog
frug86517103__frug
gerah9315303ge_rah
infra838643infra_
jetlag1434523jetlag
neural6311993neural
orfray1234393orfray
peag75431343pe__ag
peerage1089803peerage
rag45761323___rag
redraw10269853redraw
reflags1156953reflags
refract121311603refract
refrain10310043refrain
reframe1239393reframe
refry114412463refr_y
reran57329103re_ran
rerig64018483re_rig
retag63618413re_tag
retral64419743retral
rewrap11127533rewrap
scrag85916173_scrag
seabag938473seabag
sera46141393se_ra_
serac75925203se_rac
serai56830163se_rai
seral56336383se_ral
serfage1138403serfage
sprag86418693_sprag
tagrag837043tagrag
terai53525483te_rai
terga63315643te_rga
terra54419663terra_
terrae62915213terrae
terras63516973terras
tetra53417953tetra_
tetrad73612053tetrad
tetras63017623tetras
vera76828843ve_ra_
zebra1637883zebra_
zebras1737853zebras

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162325.61020092.0
3Display Results2322320.0763052.6
 (SQL Overall)1786912326.09229332.1
 
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.