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

138 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
abduct1110854(None) 
abduce1197191abduce
abducts1265311abducts
adduct1087371adduct
abduced1374842abduced
abducent13105702abducent
abduces1286242abduces
abducted1444092abducted
abductee1344782abductee
abductor1343562abductor
abject17137702abject
about75229082abou_t
abrupt1039942abrupt
abut66834952ab_u_t
addict10711202addict
adduce1076452adduce
adducts1174602adducts
adult63520652a_dult
adust64117452a_dust
deduct10610792deduct
duct75735462__duct
educt85017102_educt
induct93212742induct
subduct12107582subduct
abaca95118043ab_aca
abaci94718843ab_aci
aback134816173ab_ack
abacus10349763abacus
abaft10318063ab_aft
abbacy1536623abbacy
abbot9318453ab_bot
abdicate1348903abdicate
abducens1393483abducens
abducing1474063abducing
abductees1442753abductees
abducting1584083abducting
abduction14125413abduction
abductors1443273abductors
abet610547943ab__et
abjure1536743abjure
ablaut8313263ablaut
ablest84721833ablest
abluent939623abluent
ablush1147223ablush
abort76133583ab_ort
abought1346143abought
abound9239863abound
abreact11310823abreact
absent84016993absent
absurd935903absurd
abuse77119563ab_use
abuts75417073ab_uts
abuzz15517213ab_uzz
abvolt11169833abvolt
abwatt11410673abwatt
acquit17610323acquit
act59557843a___ct
adapt81218553a_dapt
addicts1176013addicts
adduced1274353adduced
adducent1284713adducent
adducer1184163adducer
adduces1185763adduces
adducted1343913adducted
adductor1243463adductor
adept81219643a_dept
adit56443653a_d_it
adjunct1753583adjunct
adjust1447183adjust
admit8319493a_dmit
adopt81219743a_dopt
adults7299953a_dults
adunc837433a_dunc
advect12309123advect
aeroduct1155633aeroduct
affect1448903affect
almuce10348213almuce
amount8414483amount
amuck1389563a_muck
aqueduct2052253aqueduct
ardent73022613ardent
asdic83814093asdic_
asdics9439863asdics
aspect10612823aspect
audit62527883aud_it
august739203august
aunt46553653a__unt
avaunt959603avaunt
avouch1434833avouch
baguet9316103baguet
bhut95425713_bhu_t
bluet75631193_bluet
blunt75525023_blunt
blurt77625623_blurt
bout66353293_bou_t
bract96332723_bract
bruit76126723_bruit
brunt75728753_brunt
brut66537963_bru_t
buck125129903_b_uck
bunt65850853_b_unt
bust65947783_b_ust
but55963023_b_u_t
butt65143743_b_utt
conduct121411593conduct
deduce1079253deduce
deducts1166593deducts
didact10711203didact
ducat86225903__ducat
duce76933503__duce
duci76422623__duci
duck115929173__duck
ducts85319893__ducts
duet56446263__duet
duit56241583__duit
dunt55746873__dunt
dust57142533__dust
edict84722283_edict
educe84313453_educe
educts9439893_educts
eruct74022353_eruct
indict93115573indict
induce93811533induce
inducts10259573inducts
indult73614033indult
object17135803object
obtect10129633obtect
oviduct1343443oviduct
pandect12310953pandect
product1279233product
redact9419043redact
reduce9713253reduce
reluct83916113reluct
sawdust1154533sawdust
seduce9610023seduce
subduce12106983subduce
subducts13106093subducts
viaduct1344073viaduct

Search took 6 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.1401276364.3
2DLD Change Limit1127161385.67319868.9
3Display Results1381380.0463000.0
 (SQL Overall)1786911385.85930498.5
 
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.