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 “advects” 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
advects1327601(None) 
advect12309121advect_
advents11309471advents
adverts11308511adverts
addicts1176012addicts
adducts1174602adducts
adepts9117102ad_epts
advected1534532advected
advent102613752advent_
adverbs13254272adverbs
advert103215782advert_
advices13136932advices
affects1535392affects
aspects1146742aspects
averts95715242a_verts
abducts1265313abducts
abets75621673a_be_ts
abject17137703abject_
abreacts1245633abreacts
absents93510723absents
abvolts12104373abvolts
accents113511233accents
accepts13356353accepts
acts66929863a___cts
adapts9107813ad_apts
addends10356053addends
adders84315703adde_rs
addict10711203addict_
adduces1185763adduces
adduct1087373adduct_
adeems946333ad_eems
adept81219643ad_ept_
adheres11310163adheres
adieus739633adie_us
adits66523713ad__its
adjuncts1842463adjuncts
adjusts1544513adjusts
admits9411413ad_mits
adopts998083ad_opts
adults7299953ad_ults
advances1445613advances
advecting1645113advecting
advection1545553advection
advections1645553advections
advective1845233advective
adverb12265413adve_rb
adverse1145953adverse
adverted1336103adverted
advertise1346103advertise
advice12107883advic_e
advises11138973advises
advocate1445833advocate
advocates1545883advocates
adzes155913803adze__s
affect1448903affect_
afreets1037013afreets
agents74816293a_gents
aglets73915683agle_ts
aivers94822323aive_rs
alecs76620733a_lec_s
alerts64418223a_lerts
aments85219803a_ments
analects1047703analects
arecas84817443a_recas
argents84014853argents
armets84918353arme_ts
arpents93613083arpents
arrests73312683arrests
ascents93812553ascents
aspect10612823aspect_
assents74512223assents
asserts74311793asserts
assets65617663asse_ts
attests7278813attests
audients946353audients
avens86419333a_ve_ns
avers85127313a_ve_rs
avert86029493a_vert_
aves76142603a_ve__s
avocets1235453a_vocets
bisects1137133bisects
cadets96316513cad_e_ts
cathects1545793cathects
caveats1239803caveats
civets115212543cive_ts
convects153410993convects
coverts124813813coverts
covets114819643cove_ts
davens104612913dave_ns
davits104012363dav_its
debts86418373_d_ebts
decks124822193_d_ecks
decos85522123_d_ecos
deets65330243_d_eets
defects134511523defects
dejects17389223dejects
delts65731793_d_elts
dents65031803_d_ents
detects104011093detects
devests114410473devests
diets66026643_die_ts
directs102710263directs
diverts114412033diverts
divests114510933divests
dovecots1444323dovecots
drecks13459203_drecks
ducts85319893_d_ucts
duets65323883_due_ts
duvets1039223duve_ts
edicts94911703ed_icts
educts9439893ed_ucts
effects1535283effects
ejects15409953_ejects
elects83315003_elects
erects84116183_erects
events94814073_events
everts94514893_everts
evicts11368553_evicts
expects1866883expects
exsects1655573exsects
gadgets10348683gadge_ts
harvests14246173harvests
infects12279713infects
injects16257453injects
insects93710843insects
invents102812053invents
inverts103211953inverts
invests10319683invests
objects18123693objects
obverts1235403obverts
pandects1335843pandects
refects124012743refects
rejects163910693rejects
resects94115593resects
reverts104715043reverts
revests104413733revests
revets94022173reve_ts
rivets94417113rive_ts
sects75622893__sects
selects91912143selects
vents86125933__vents
verts85724733__verts
vests85325983__vests
vets76835093__ve_ts
wadsets1136443wadse_ts

Search took 9 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 Limit1340271458.47015823.7
3Display Results1451450.0463152.2
 (SQL Overall)1786911458.67220605.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.