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 “deduct” 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
deduct1061079(None) 
deduce1079251deduce
deducts1166591deducts
educt85017101_educt
abduct11108542abduct
adduct1087372adduct
debut86024142debu_t
decoct11313782decoct
deduced1266682deduced
deduces1168792deduces
deducted1356242deducted
defect124816172defect
defunct1345772defunct
degust8310252degust
deject164512842deject
delict94320332delict
depict113514792depict
detect94217402detect
deuce84517492de_uce
didact10711202didact
duct75735462__duct
edict84722282_edict
educe84313452_educe
educts9439892_educts
eruct74022352_eruct
induct93212742induct
redact9419042redact
reduce9713252reduce
reluct83916112reluct
seduce9610022seduce
abduce1197193abduce
abducts1265313abducts
addict10711203addict
adduce1076453adduce
adducts1174603adducts
adult63520653_adult
adust64117453_adust
aeroduct1155633aeroduct
aqueduct2052253aqueduct
beaut75135213beau_t
bedeck1536213bedeck
bedsit9312843bedsit
bedu75923703bedu__
beduin939713beduin
bedumb1335063bedumb
bedunce1235683bedunce
cedula977643cedula
conduct121411593conduct
daunt65929083d_aunt
daut56443563d_au_t
deadest93014883deadest
dealt65234283de_alt
debauch15134423debauch
debit85727853de_bit
debouch15124253debouch
debt77139023de__bt
debug94210063debu_g
debugs10467823debugs
debunk1365113debunk
debuts93911753debuts
decant93524223decant
deceit93018213deceit
decent94023703decent
deck115827753de__ck
deco76125973de__co
decocts1237833decocts
decury1277963decury
dedal75719023ded_al
dedans85915073dedans
dedicate12312803dedicate
deducing1336423deducing
deducting1436843deducting
deduction1377083deduction
deductive1645473deductive
deet57356583de__et
deface123113863deface
defat95426693de_fat
default1147893default
defeat103817163defeat
defects134511523defects
deficit1339683deficit
deflect13399973deflect
deft85540223de__ft
defuel10348933defuel
defund11447983defund
defuse105712723defuse
defuze19487843defuze
degum94711903degu_m
degums10438623degums
degusts936063degusts
dehort104618103dehort
deice84320033de_ice
deist64633593de_ist
dejecta17376363dejecta
dejects17389223dejects
delft95623323de_lft
delicts104012253delicts
delist74625053delist
delt57855273de__lt
delude81910673delude
deluge8189403deluge
deluxe14197303deluxe
demast9517063demast
dement93825153dement
demic105119193demic_
demit84832303de_mit
demount1049743demount
demur8311163demu_r
demure9311533demure
demurs939773demurs
dent57158413de__nt
denude8169353denude
depart94720563depart
depicts12358463depicts
deport94922393deport
depot85727923de_pot
depute94512303depute
deputy12426713deputy
derat65044083de_rat
desalt7518313desalt
desert72725493desert
desist74818813desist
despot93413293despot
destruct1148383destruct
detach12310413detach
detects104011093detects
detent73624483detent
detest74122843detest
detick1339383detick
detract101414633detract
deuced104112123de_uced
deuces94015513de_uces
devest104418703devest
device124512163device
devout10712993devout
didacts1186063didacts
didst74619623did_st
diquat1639763diquat
direct93817333direct
donut6324513donu_t
doubt8720093d_oubt
douce85518423d_ouce
ducat86225903__ducat
duce76933503__duce
duci76422623__duci
duck115929173__duck
ducts85319893__ducts
duet56446263__duet
duit56241583__duit
dunt55746873__dunt
dust57142533__dust
edicts94911703_edicts
edit54934873_ed_it
educate10310213_educate
educed10418853_educed
educes94011953_educes
eductor1035863_eductor
eject145016043_eject
elect74327033_elect
enact73525363_enact
epact94921533_epact
erect74129333_erect
eructs83610793_eructs
erupt74220063_erupt
evict104417143_evict
exact143516933_exact
exult122814123_exult
geoduck1542463geoduck
gweduc1341743gweduc_
gweduck1841483gweduck
gweducs1441303gweducs
heuch135312333he_uch
indict93115573indict
induce93811533induce
inducts10259573inducts
indult73614033indult
jesuit1339583jesuit
medic104619653medic_
medick154010133medick
medico113711163medico
medics114115353medics
medusa936293medusa
oviduct1343443oviduct
pedant9319493pedant
penult8314653penult
prededuct1543103prededuct
predict12315323predict
product1279233product
react74634333re_act
rebut75927383rebu_t
recut74729243recu_t
redacts10510943redacts
redipt94116743redipt
redock134311543redock
redoubt10167843redoubt
redout71820253redout
redub84212413redu_b
redubs9358383redubs
reduced11610323reduced
reducer1059003reducer
reduces10513343reduces
reductor1156433reductor
redux133811103redu_x
refect114319333refect
reinduct1176153reinduct
reject154116283reject
relict83623903relict
relucts9369673relucts
resect84424703resect
result6318223result
sect67443623se__ct
seduced1186753seduced
seducer1056503seducer
seduces1069283seduces
sedum84115573sedu_m
sedums93910483sedums
select82621173select
subduct12107583subduct
teuch105214853te_uch
verdict1339583verdict
viaduct1344073viaduct

Search took 10 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.623286823.4
2DLD Change Limit1127162219.03312478.2
3Display Results2212210.0762907.9
 (SQL Overall)1786912219.73218361.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.