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

145 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
defocus133528(None) 
refocus1236971refocus
decocts1237832decocts
defaces133213402defaces
defects134511522defects
defoams1336192defoams
defocused16143532defocused
defocuses15134492defocuses
defogs1156682defo_gs
deforces14248402deforces
deforms1337802deforms
defrocks1844112defrocks
focus105815882__focus
prefocus1544742prefocus
befogs1246453befo_gs
befools1236433befools
befoul1137253befo_ul
befouls1236053befouls
bemocks1735373bemocks
cercus105013153ce_rcus
cerous85821203cero_us
crocus104813173_crocus
deacons10310393deacons
debones103315113debones
debouch15124253debouch
decks124822193de__cks
decoct11313783decoc_t
decodes113914983decodes
decorous1138853decorous
decors94017773deco_rs
decorum1246943decorum
decorums1344993decorums
decos85522123de__cos
decoys123911283deco_ys
deduces1168793deduces
deducts1166593deducts
deface123113863defac_e
defaced142910973defaced
defacer132810363defacer
defacers14237993defacers
defames132812253defames
defangs1235363defangs
defats105114553def_ats
defeats113511233defeats
defect124816173defec_t
defences1439633defences
defends12358773defends
defers105116943def_ers
deficit1339673deficit
deficits1447273deficits
defiers113913993defiers
defies104624053def_ies
defiles114016843defiles
defines114118683defines
defis96717503def__is
defleas1147223defleas
deflects14336733deflects
defoam1238563defo_am
defocusing1752813defocusing
defocussed17152373defocussed
defocusses16152843defocusses
defog1048523defo__g
deforce13267243deforce
deforced15247373deforced
deforcer14246903deforcer
deforcers15265503deforcers
deforest1238793deforest
deform1259623defo_rm
defrags1236193defrags
defraud1243913defraud
defrauds1343243defrauds
defrays1436113defrays
defrock1744643defroc_k
defrosts1244833defrosts
defuels11296983defuels
defunds12376753defunds
defuse105712723def__use
defuses114814593defuses
defuzes20398303defuzes
dehorns11428363dehorns
dehorts11379773dehorts
deices94119373de_ices
dejects17389223dejects
delicts104012253delicts
delouse839833delo_use
demobs11429483demo_bs
demons94917723demo_ns
demos86022993demo__s
demoses103815823demoses
demotes104717673demotes
denotes83817003denotes
depicts12358463depicts
depones103717093depones
deports105012883deports
deposes103117213deposes
depots94716343depo_ts
desorbs10437713desorbs
detects104011093detects
deticks1437353deticks
detour778193deto_ur
detours858043detours
detoxes1538803detoxes
deuces94015513de_uces
devices133212583devices
devious1138523devious
devoices14307413devoices
devoirs1175783devoirs
devons104512253devo_ns
devotes113713753devotes
devour1076703devo_ur
devours1166643devours
devout10712993devo_ut
dewools1145593dewools
deworms1338033deworms
discus94512113d_iscus
docks126022313d__ocks
docs75631153d__oc_s
doofus1036163d_oofus
dufus94010813duf__us
durocs9569703duroc_s
ecus65421463_e__cus
epochs1335813_epochs
exodus1434653_exodus
ficus105015493__ficus
fucus105515893__fucus
hocus104715203__hocus
locus74819993__locus
meous76120063me_o_us
misfocus1543453misfocus
overfocus1744263overfocus
pelorus939273pelorus
recocks154711463recocks
redocks14409933redocks
refaces123216743refaces
refects124012743refects
refocused15144653refocused
refocuses14135953refocuses
refolds11298953refolds
reforms1239823reforms
relocks134411293relocks
rufous948273rufo_us
serous65023563sero_us
setous64917373seto_us
venous93713193veno_us
xenopus1642983xenopus

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.440406115.9
2DLD Change Limit1340271456.76619808.9
3Display Results1451450.0602416.7
 (SQL Overall)1786911457.26624592.8
 
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.