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

188 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
advect1230912(None) 
advects13276011advects
advent102613751advent
advert103215771advert
abject17137702abject
addict10711202addict
adduct1087372adduct
adept81219642ad_ept
advected1534532advected
advents11309472advents
adverb12265412adverb
adverts11308512adverts
advice12107882advice
affect1448902affect
aspect10612822aspect
avert86029492a_vert
abduct11108543abduct
abet610547943a_be_t
ablest84721833ablest
abreact11310823abreact
absent84016993absent
abvolt11169833abvolt
accent105116263accent
accept123210623accept
act59557843a___ct
adapt81218553ad_apt
added84918433adde_d
addend9458453addend
adder75419593adde_r
adders84315703adders
addicts1176013addicts
addrest958623addrest
adduce1076453adduce
adducts1174603adducts
adeem8311803ad_eem
adeems946333adeems
adepts9117103ad_epts
adhere10310333adhere
adieu6417423adie_u
adieus739633adieus
adieux1444283adieux
adit56443653ad__it
adjunct1753573adjunct
adjust1447173adjust
admen84516183adme_n
admit8319493ad_mit
admixt1637333admixt
adnexa1433673adnexa
adopt81219743ad_opt
adrift10313113adrift
adroit7518783adroit
adult63520653ad_ult
adunc837433adunc_
adust64117453ad_ust
advance1346043advance
advecting1645113advecting
advection1545553advection
advective1845233advective
adverbs13254273adverbs
adverse1145953adverse
adverted1336103adverted
advices13136933advices
advise10139223advise
advocate1445833advocate
adze1412820573adze__
adzed166012543adze_d
adzes155913803adze_s
affects1535393affects
afreet9315153afreet
agent65829643a_gent
aglet65534143agle_t
airest63825263airest
aiver85725163aive_r
aivers94822323aivers
albeit8314343albeit
alec66430063a_lec_
alecs76620733a_lecs
alert54740653a_lert
ament76036543a_ment
anent54931843a_nent
apiece10510083apiece
aptest82917513aptest
ardent73022613ardent
areca75618633a_reca
argent74023663argent
armet76739453arme_t
arpent84822093arpent
arrest63722633arrest
ascent84519653ascent
aspects1146743aspects
assent65119953assent
assert64922573assert
asset55932263asse_t
attent62818323attent
attest62618613attest
audient8312303audient
avant86224663a_vant
avast85519363a_vast
ave67748703a_ve__
avens86419333a_vens
aver75931883a_ve_r
avers85127313a_vers
averts95715243a_verts
aves76142603a_ve_s
avocet11412683a_vocet
baddest112611143baddest
bisect10312873bisect
cadent94120353cad_ent
cadet85339333cad_e_t
cathect1439863cathect
caveat11417723caveat
civet105828733cive_t
convect143114483convect
covert114925503covert
covet105638943cove_t
daven94916473dave_n
davens104612913davens
davit93424593dav_it
debt77139023_d_ebt
deck115827753_d_eck
deco76125973_d_eco
deet57356583_d_eet
defect124816173defect
deft85540223_d_eft
deject164512843deject
delt57855273_d_elt
dent57158413_d_ent
detect94217403detect
devest104418703devest
diet57357533_die_t
direct93817333direct
divert103922813divert
divest106820073divest
doest65829523_doest
dovecot1356733dovecot
dreck124812803_dreck
drest65530343_drest
duct75735463_d_uct
duet56446263_due_t
duvet9321873duve_t
dwelt94316523_dwelt
edict84722283ed_ict
educt85017103ed_uct
effect1437443effect
eject145016043_eject
elect74327033_elect
erect74129333_erect
event85924443_event
evert84929513_evert
evict104417143_evict
expect1758903expect
exsect1558503exsect
gadget93616173gadge_t
haddest122711993haddest
harvest132112753harvest
idlest74014863idlest
infect113413443infect
inject153210233inject
insect83916583insect
invent93316363invent
invert94120083invert
invest93014843invest
livest95315733livest
maddest112311213maddest
naivest10309473naivest
object17135803object
obtect10129633obtect
obvert11412993obvert
oddest81710863oddest
overt85630723_overt
pandect12310953pandect
refect114319333refect
reject154116283reject
resect84424703resect
revert93529113revert
revest94623603revest
revet84938843reve_t
rivet85636363rive_t
saddest92412383saddest
sect67443623__sect
select82621173select
unvext1658173unvext
vent76049053__vent
vert77249373__vert
vest75743603__vest
vet65958523__ve_t
vext146927763__vext
wadset10314303wadse_t

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 Limit1127161885.69019809.5
3Display Results1881880.0603133.3
 (SQL Overall)1786911885.89030338.0
 
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.