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

199 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
exserts146701(None) 
exerts133712291ex_erts
experts1659061experts
exsects1655571exsects
exsert13414361exsert_
asserts74311792asserts
deserts82513052deserts
desserts9247922desserts
enserfs1035482enserfs
everts94514892e_verts
excepts1885202excepts
excerpts1943742excerpts
exert124624142ex_ert_
exhorts1746312exhorts
expects1866882expects
expert15515352expert_
exports1647982exports
exsect1558502exsect_
exserted1636212exserted
extents142610172extents
externs1438232externs
extorts1447752extorts
inserts74013992inserts
absents93510723absents
adverts11308513adverts
alerts64418223_alerts
assents74512223assents
assert64922583assert_
assets65617663asse_ts
assorts73310153assorts
averts95715243_averts
axseeds1533393axseeds
berserks1433993berserks
besets85718803bese_ts
bisects1137133bisects
caserns94711223caserns
censers94313903censer_s
cherts115617233_cherts
coexerts1734883coex_erts
cosets85824403cose_ts
coverts124813813coverts
desert72725493desert_
dessert82916453dessert_
disserts92411813disserts
diverts114412033diverts
dosers75723633doser_s
eagers74523683eager_s
easels65914553ease_ls
eases56041613ease__s
easters75125683easter_s
easts57530323eas__ts
eaters65535953eater_s
ebbets10376833ebbe_ts
edgers84413923edger_s
effects1535283effects
efforts1334703efforts
egers65120373e_ger_s
egests74411253e_gests
eggers84612583egger_s
egrets72712243egre_ts
eiders74321363eider_s
ejects15409953e_jects
elders74817303elder_s
elects83315003e_lects
eluents738703eluents
elvers93814983elver_s
embers104116183ember_s
emeers83314183emeer_s
emmers104013223emmer_s
emmets10349153emme_ts
enders74324053ender_s
enserf9310763enser_f
ensures73315903ensures
enters64425643enter_s
erasers74413943eraser_s
erects84116183e_rects
erses55826803erse__s
escorts9418403escorts
escots84211743e_scots
eses45336103e_se__s
eskers105312223esker_s
esprits938393e_sprits
esses56422973esse__s
esters64627733ester_s
estrus61912113e_strus
ethers94518413ether_s
events94814073e_vents
evert84929513e_vert_
ewers86018823e_wer_s
exacts15359613ex_acts
exahertz2743243exahertz
exalts13328313ex_alts
exceeds1733843exceeds
excels1536663exce_ls
except1797653except_
excerpt1845943excerpt
excess1546053exce_ss
excreta1674623excreta
excrete1667163excrete
excretes1787573excretes
excusers1734443excuser_s
execs14539723ex_e_cs
exempts1844023exempts
exerted152210053ex_erted
exes116530813ex_e__s
exhort16410803exhort_
exilers14419733exiler_s
existents1644983existents
exists134710913ex_ists
exits125515913ex__its
exoderms1864493exoderms
expats1537683ex_pats
expect1758903expect_
expels1547173expe_ls
expends17217083expends
experted1838053experted
expertise1847933expertise
expertism2045433expertism
expertly2044703expertly
expires1638683expires
export15412183export_
exposers1736133exposer_s
express1637493express
exsecants1893403exsecants
exsected1835673exsected
exsertile1644593exsertile
exserting1736663exserting
exsertion1646853exsertion
exsertions1746743exsertions
extends15227113extends
extent132714913extent_
extern1348473exter_n
externe1438573externe
externes1539833externes
extort13513973extort_
extras13310223ex_tras
exults13257633ex_ults
exurbs1534423ex_urbs
eyers86521333e_yer_s
geysers1135703geyser_s
hexers165612753hex_er_s
hosers95223963hoser_s
inerts64517023_inerts
inexperts1842973inexperts
insects93710843insects
insert64325253insert_
insets64016133inse_ts
inverts103211953inverts
keysets1434343keyse_ts
lasers64925703laser_s
leasers74717843leaser_s
losers65123583loser_s
masers84623453maser_s
miseats92815783miseats
misers85025703miser_s
musers84719103muser_s
nerts55924983__nerts
obverts1235403obverts
onsets64013543onse_ts
outserts8309803outserts
oxcarts1634313oxcarts
oxhearts1842903oxhearts
oxters134813273oxter_s
perverts1337533perverts
posers84223973poser_s
rasers64526783raser_s
reasserts945983reasserts
reinserts946423reinserts
reseats74319583reseats
resects94115593resects
resents74221223resents
resets65427613rese_ts
resorts74817193resorts
reverts104715043reverts
risers64624783riser_s
rosets65819953rose_ts
seats54844343__seats
sects75622893__sects
seisers73816393seiser_s
septs75420603__septs
seres55448893__seres
serfs84922013__serfs
sers45746653__ser_s
sets45549503__se_ts
setts55124323__setts
sextets1497143sexte_ts
sexts125118383__sexts
sorts54536663__sorts
teasers75317243teaser_s
unseats73012853unseats
unsets64116163unse_ts
upsets8409683upse_ts
users55817573_user_s
versers103813523verser_s
versets103913103verse_ts
verts85724733__verts
vexers165210403vex_er_s
wisents10249063wisents
xerus12313333_x_erus

Search took 7 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.390458182.1
2DLD Change Limit1340271996.11021935.7
3Display Results1991990.0802487.5
 (SQL Overall)1786911996.58027156.7
 
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.