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

203 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
deducts116659(None) 
deduces1168791deduces
deduct10610791deduct_
educts9439891_educts
abducts1265312abducts
adducts1174602adducts
debuts93911752debu_ts
decocts1237832decocts
deduce1079252deduc_e
deduced1266682deduced
deducted1356242deducted
defects134511522defects
degusts936062degusts
dejects17389222dejects
delicts104012252delicts
depicts12358462depicts
detects104011092detects
deuces94015512de_uces
didacts1186062didacts
ducts85319892__ducts
edicts94911702_edicts
educes94011952_educes
educt85017102_educt_
eructs83610792_eructs
inducts10259572inducts
redacts10510942redacts
reduces10513342reduces
relucts9369672relucts
seduces1069282seduces
abduces1286243abduces
abduct11108543abduct_
addicts1176013addicts
adduces1185763adduces
adduct1087373adduct_
adults7299953_adults
aeroducts1243873aeroducts
aqueducts2151143aqueducts
beauts86015283beau_ts
bedecks1635793bedecks
bedsits1037563bedsits
beduins1039123beduins
bedumbs1433633bedumbs
bedunces1345513bedunces
cedulas1058503cedulas
conducts13118703conducts
daunts75014083d_aunts
dauts67822243d_au_ts
debits94214503de_bits
debts86418373de__bts
debugs10467823debu_gs
debunks1433763debunks
debut86024143debu_t_
decants103514443decants
deceits102810883deceits
decks124822193de__cks
decoct11313783decoct_
decos85522123de__cos
dedans85915073ded_ans
dedicate12312803dedicate
dedicates13311693dedicates
deducing1336423deducing
deducting1436833deducting
deduction1377073deduction
deductions1467123deductions
deductive1645453deductive
deets65330243de__ets
defaces133213403defaces
defats105114553de_fats
defaults1243333defaults
defeats113511233defeats
defect124816173defect_
deficits1447273deficits
deflects14336733deflects
defocus1335283defocus
defuels11296983defuels
defunct1345773defunct_
defunds12376753defunds
defuses114814593defuses
defuzes20398303defuzes
degums10438623degu_ms
degust8310253degust_
dehorts11379773dehorts
deices94119373de_ices
deists74916433de_ists
deject164512843deject_
dejecta17376363dejecta
delfts10439673de_lfts
delict94320333delict_
delists84414173delists
delts65731793de__lts
deludes91810643deludes
deluges9169263deluges
demasts1089223demasts
dements103016623dements
demits94918073de_mits
demounts1135473demounts
demurs939773demu_rs
dents65031803de__nts
denudes91510043denudes
departs104310683departs
depict113514793depict_
deports105012883deports
depots94716343de_pots
depute94512303depu_te
deputes104911783deputes
deputy12426713depu_ty
derats74625063de_rats
desalts839573desalts
deserts82513053deserts
desists83611723desists
despots10319683despots
destructs1245773destructs
detect94217403detect_
detents83615153detents
detests83711743detests
deticks1437353deticks
detracts11138833detracts
deuce84517493de_uc_e
deuced104112123de_uced
devests114410473devests
devices133212583devices
didact10711203didact_
diquats1745973diquats
directs102710263directs
donuts7410583donu_ts
doubts968733d_oubts
ducats95011763__ducats
duces86327473__duces
ducks124823213__ducks
duct75735463__duct_
duets65323883__duets
duits65021883__duits
dunts65828413__dunts
dusts65923563__dusts
edict84722283_edict_
edits65819033_ed_its
educate10310213_educate
educates1139613_educates
educe84313453_educ_e
educed10418853_educed
eductor1035863_eductor
eductors1135983_eductors
ejects15409953_ejects
elects83315003_elects
enacts84012973_enacts
epacts105010393_epacts
erects84116183_erects
eruct74022353_eruct_
erupts8348903_erupts
evicts11368553_evicts
exacts15359613_exacts
exults13257633_exults
geoducks1642283geoducks
gweducks1941443gweducks
gweducs1441303gweduc_s
heuchs14447923he_uchs
indicts103210723indicts
induces103611813induces
induct93212743induct_
indults8289493indults
jesuits1436323jesuits
medicks16368413medicks
medicos12339833medicos
medics114115353medic_s
medusas1036213medusas
oviducts1442073oviducts
pedants10310113pedants
penults937123penults
prededucts1642223prededucts
predicts1339613predicts
products1376513products
reacts83616603re_acts
rebuts84015193rebu_ts
recuts83817373recu_ts
redact9419043redact_
redocks14409933redocks
redoubts11153973redoubts
redouts81411653redouts
redubs9358383redu_bs
reduce9713253reduc_e
reduced11610323reduced
reducer1059003reducer
reducers1147263reducers
reductase1244543reductase
reductor1156433reductor
reductors1246523reductors
refects124012743refects
reinducts1284313reinducts
rejects163910693rejects
relicts94414593relicts
reluct83916113reluct_
resects94115593resects
results739833results
sects75622893se__cts
seduce9610023seduc_e
seduced1186753seduced
seducer1056503seducer
seducers1145383seducers
sedums93910483sedu_ms
selects91912143selects
subducts13106093subducts
verdicts1446013verdicts
viaducts1442293viaducts

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.1561145455.1
2DLD Change Limit1340272037.37618170.7
3Display Results2032030.0762671.1
 (SQL Overall)1786912037.60823487.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.