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

245 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
experts165906(None) 
exerts133712291ex_erts
expects1866881expects
expert15515351expert_
exports1647981exports
exserts1467011exserts
everts94514892e_verts
excepts1885202excepts
excerpts1943742excerpts
exert124624142ex_ert_
exhorts1746312exhorts
expats1537682exp_ats
expect1758902expect_
expels1547172expe_ls
expends17217082expends
experted1838052experted
expertise1847932expertise
expertism2045432expertism
expertly2044702expertly
expires1638682expires
export15412182export_
express1637492express
exsects1655572exsects
exsert13414362exsert_
extents142610172extents
externs1438232externs
extorts1447752extorts
inexperts1842972inexperts
adverts11308513adverts
alerts64418223_alerts
amperes11313983amperes
apers76629133_aper_s
arpents93613083arpents
aspects1146743aspects
aspers86220313asper_s
asserts74311793asserts
averts95715243_averts
beepers113612383beeper_s
capers105428143caper_s
cherts115617233_cherts
coexerts1734883coex_erts
copers104629843coper_s
coverts124813813coverts
departs104310683departs
deperms1236603deperms
deports105012883deports
deserts82513053deserts
desserts9247923desserts
diverts114412033diverts
dopers95522483doper_s
dupers94615603duper_s
eagers74523683eager_s
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
elopers95112943eloper_s
eluents738703eluents
elvers93814983elver_s
embers104116183ember_s
emeers83314183emeer_s
emmers104013223emmer_s
emmets10349153emme_ts
emperies12314563emperies
emperor1155483emperor
emperors1256123emperors
empery1348683emper_y
empires1139853empires
empress1138163empress
enders74324053ender_s
enserfs1035483enserfs
enters64425643enter_s
epacts105010393e_pacts
epees75219833e_pe_es
erects84116183e_rects
escorts9418403escorts
eskers105312223esker_s
esparto944233esparto
espartos1044333espartos
esprits938393esprits
esters64627733ester_s
ethers94518413ether_s
events94814073e_vents
evert84929513e_vert_
ewers86018823e_wer_s
exacts15359613ex_acts
exahertz2743243exahertz
exalts13328313ex_alts
exceeds1733843exceeds
excels1536663exce_ls
except1797653except_
excerpt1845943excerpt
excess1546053exce_ss
excreta1674623excreta
excrete1667163excrete
excretes1787573excretes
execs14539723ex_e_cs
exempts1844023exempts
exerted152210053ex_erted
exes116530813ex_e__s
exhort16410803exhort_
exilers14419733exiler_s
exists134710913ex_ists
exits125515913ex__its
exoderms1864493exoderms
expands17195733expands
expat14313813exp_at_
expected2036743expected
expecter1936513expecter
expecters2045473expecters
expedite1847263expedite
expedites1946163expedites
expel1448233expe__l
expend16247503expe_nd
expense16127873expense
expenses17138373expenses
experting1938053experting
expertises1947103expertises
expertisms21114493expertisms
expertize2746583expertize
expertizes28106013expertizes
expertness1944823expertness
expiate16910593expiate
expiates17810213expiates
expire1538023expir_e
expired1736403expired
expirer1635993expirer
expirers1735123expirers
expiries1747753expiries
expiry1834653expir_y
explants1737023explants
exploits1745973exploits
explores1746253explores
exponents1844333exponents
exported1837133exported
exporter1737363exporter
exporters1846253exporters
expos1449203exp__os
exposers1736133exposer_s
exposes1639963exposes
exposits1747243exposits
expresso1743883expresso
exsect1558503exsect_
exserted1636213exserted
extends15227113extends
extent132714913extent_
extern1348473exter_n
externe1438573externe
externes1539833externes
extort13513973extort_
extras13310223ex_tras
exults13257633ex_ults
exurbs1534423ex_urbs
eyers86521333e_yer_s
gapers94520473gaper_s
heapers123616673heaper_s
helpers123311853helper_s
hexers165612753hex_er_s
hopers114222973hoper_s
hypers144811913hyper_s
imparts11298533imparts
imports11309623imports
inerts64517023_inerts
inexpert1746083inexpert_
inserts74013993inserts
inverts103211953inverts
japers154616173japer_s
jeepers16399193jeeper_s
jetports1743533jetports
keepers133410983keeper_s
leapers93716663leaper_s
lepers84817323leper_s
lopers84424143loper_s
mopers104220373moper_s
nerts55924983__nerts
nonexperts1953103nonexperts
obverts1235403obverts
operas8312453_operas
oxcarts1634313oxcarts
oxhearts1842903oxhearts
oxters134813273oxter_s
papers105125323paper_s
parts77743373__parts
peats76140193__peats
peepers113713673peeper_s
pelts76128813__pelts
peppers103311443pepper_s
peres76246643__peres
peris75537073__peris
perks115325803__perks
perms95524513__perms
perpents122312043perpents
perps95521483__perps
pert66759323__pert_
perverts1337533perverts
pervs105117373__pervs
pests75933273__pests
pets66248333__pe_ts
pipers104318663piper_s
pipets105714773pipe_ts
ports75934593__ports
rapers84327183raper_s
reapers93520453reaper_s
reexports1843243reexports
repeats94316053repeats
repents93717623repents
reperks13298093reperks
reports94916213reports
respects1247703respects
reverts104715043reverts
ropers84325903roper_s
seaports1038463seaports
serpents102410373serpents
sexpots1636293sexp_ots
sextets1497143sexte_ts
spelts84614643_spelts
sperms102512603_sperms
spirts85317133_spirts
sports84619183_sports
spurts84814973_spurts
supers84622403super_s
tapers84025813taper_s
temperas12278233temperas
tempers113513013temper_s
tempests1234443tempests
topers85025323toper_s
unexpert1744343unexpert_
uppers102912293upper_s
verts85724733__verts
vespers1239033vesper_s
vexers165210403vex_er_s
vipers114914533viper_s
weepers123511973weeper_s
wipers115416083wiper_s
xerus12313333_x_erus
yelpers12348203yelper_s

Search took 8 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 Limit1340272456.78319759.3
3Display Results2452450.0763223.7
 (SQL Overall)1786912457.24924650.4
 
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.