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

162 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
expiates1781021(None) 
expiate16910591expiate_
expiated18168521expiated
epilates10313502e_pilates
excites16310632exci_tes
expatiates1944892expatiates
expats1537682exp_at_s
expiator1747042expiator
expiators1846802expiators
expires1638682expi_res
expiries1747752expiries
explicates2196662explicates
exudates1636622exudates
exuviates1945372exuviates
opiates9312142_opiates
aspirates1139613aspirates
aviates10313073_aviates
axites134913833ax_i_tes
bedplates1445493bedplates
capiases1239253capiases
ciliates10413453ciliates
depilates12310923depilates
despites11410313despi_tes
deviates12312743deviates
educates1139623educates
elates65032363e__lates
elevates111110423elevates
elites66027123e_li_tes
eluates72014683e_luates
eluviates1246103eluviates
emaciates1347883emaciates
emanates10311333emanates
emirates101214853emirates
empales112411433emp_ales
emphases1568353emphases
empires1139853empi_res
emplaces1438413emplaces
emplanes1239503emplanes
emulates10312573emulates
enates64026433e__nates
endites83717063endi_tes
endplates1246843endplates
enplanes1039483enplanes
epidotes1147023e_pidotes
epilate9314283e_pilate_
epilated11310753e_pilated
epistles1047783e_pistles
epitases1038933e_pitases
equates162012323e_quates
equites162212493equi_tes
eradiates102010783eradiates
ergates8314493e_rgates
espials937093espia_ls
espies83716803espi__es
estates74520183e_states
estimates11911363estimates
estivates12109753estivates
evites94916473e_vi_tes
exabytes2043613exabytes
excavates2144683excavates
excides1738343exci_des
exciples1964773exciples
excises1638933exci_ses
excite15310883exci_te_
excited1737853exci_ted
exciter1637753exci_ter
exciters1736323exci_ters
exclaves2044923exclaves
excoriates1946323excoriates
excretes1787573excretes
execrates1839563execrates
executes1736533executes
exegetes1655313exegetes
exfoliates2063703exfoliates
exhales1737143ex_hales
exiles134816403ex_i_les
exines135715803ex_i_nes
existed1538473ex_isted
exists134710913ex_ist_s
exited144712523ex_i_ted
exits125515913ex_i_t_s
expands17195733exp_ands
expanse16145603exp_anse
expanses17156173expanses
expat14313813exp_at__
expatiate1845423expatiate_
expatiated2044203expatiated
expatriates2053543expatriates
expected2036743expected
expecter1936513expecter
expecters2045473expecters
expects1866883expect_s
expedites1946163expedites
expenses17138373expenses
experted1838053experted
experts1659063expert_s
expiable1946113expiable
expiating1938543expiating
expiation18710423expiation
expiations1959663expiations
expiatory2145183expiatory
expire1538023expi_re_
expired1736403expi_red
expirer1635993expi_rer
expirers1735123expirers
explains1766443explains
explanted1944973explanted
explants1737023explants
explicate20117493explicate_
explicated22106103explicated
explodes1845803explodes
explores1746253explores
exported1837133exported
exporter1737363exporter
exporters1846253exporters
exports1647983export_s
exposes1639963exp_oses
expulses1774813expulses
expunges1843573expunges
expurgates2043523expurgates
exsiccates2142803exsiccates
extirpates1943683extirpates
extricates1998243extricates
extubates1844843extubates
exudate1537093exudate_
exuviate1846063exuviate_
exuviated2044783exuviated
filiates11412663filiates
foliates11412753foliates
helpmates1645513helpmates
herniates1247333herniates
labiates101011513labiates
lapidates1247143lapidates
mediates112814063mediates
muriates10312083muriates
obviates1345163obviates
opiate8513463_opiate_
opiated1039483_opiated
oppilates1345453oppilates
oxalates1557063oxalates
oxidates1636333oxidates
pates76047893__p_ates
pirates93020333__pirates
pistes85325633__pistes
plates85432243__plates
prates84633163__prates
pupates113311433pup_ates
radiates92415293radiates
replates102919273replates
respites10513243respi_tes
satiates8314633satiates
seriates82620673seriates
sopites93817173sopi_tes
spates85028173_sp_ates
spites84127333_spi_tes
striates83417083striates
supinates1139553supinates
templates1348273templates
updates10329793_updates
uprates93814863_uprates
variates111214983variates
vitiates112311433vitiates

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621627.12620511.1
3Display Results1621620.0762131.6
 (SQL Overall)1786911627.62223444.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.