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

166 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
expiate1691059(None) 
expiated18168521expiated
expiates17810211expiates
epilate9314282e_pilate
excite15310882exci_te
expat14313812exp_at_
expatiate1845422expatiate
expats1537682exp_ats
expiable1946112expiable
expiator1747042expiator
expire1538022expi_re
explicate20117492explicate
exudate1537092exudate
exuviate1846062exuviate
opiate8513462_opiate
aspirate1039943aspirate
aviate9315203_aviate
axite125218253ax_i_te
bedplate1346223bedplate
capitate121712183capitate
ciliate9514603ciliate
depilate11311703depilate
despite10410123despi_te
deviate11312713deviate
echinate1359403echinate
educate10310213educate
elate55335883e__late
elevate101110373elevate
elite56230183e_li_te
eluate62315433e_luate
eluviate1146953eluviate
emaciate1248753emaciate
emanate9312473emanate
emirate91015833emirate
empale102611263emp_ale
empire1039323empi_re
emplace1338263emplace
emplane11410013emplane
emulate9314123emulate
enate54428153e__nate
endite73817593endi_te
endplate1147083endplate
enplane939723enplane
epidote1037393e_pidote
epilated11310753e_pilated
epilates10313503e_pilates
epistle957893e_pistle
equate152012463e_quate
eradiate91911753eradiate
ergate7315143e_rgate
espial839543espia_l
espials937093espials
estate64719763e_state
estimate10912003estimate
estivate111010003estivate
evite85317683e_vi_te
exabyte1943523exabyte
exanimate1845663exanimate
excavate2045053excavate
excide1638423exci_de
exciple1874683exciple
excise1538553exci_se
excited1737853exci_ted
exciter1637753exci_ter
excites16310633exci_tes
exclave1945193exclave
excoriate1846883excoriate
excrete1667163excrete
execrate1739653execrate
execute1636783execute
exegete1545773exegete
exfoliate1954133exfoliate
exhale1636873ex_hale
exile126117653ex_i_le
exine125518493ex_i_ne
exist124618943ex_ist_
existed1538473ex_isted
exists134710913ex_ists
exit114428673ex_i_t_
exited144712523ex_i_ted
exits125515913ex_i_ts
expand16236573exp_and
expanse16145603expanse
expatiated2044203expatiated
expatiates1944893expatiates
expatriate1954043expatriate
expect1758903expect_
expected2036743expected
expecter1936513expecter
expects1866883expects
expedite1847263expedite
expense16127873expense
expert15515353expert_
experted1838053experted
experts1659063experts
expiating1938543expiating
expiation18710423expiation
expiators1846803expiators
expiatory2145183expiatory
expired1736403expired
expirer1635993expirer
expires1638683expires
expiries1747753expiries
expiry1834653expi_ry
explain1667043explain
explant16310133explant
explanted1944973explanted
explants1737023explants
explicated22106103explicated
explicates2196663explicates
explode1745963explode
explore1646613explore
export15412183export_
exported1837133exported
exporter1737363exporter
exports1647983exports
expose1549523exp_ose
expulse1674513expulse
expunge1743313expunge
expurgate1943823expurgate
exsiccate2043143exsiccate
extirpate1844023extirpate
extricate1869073extricate
extubate1745103extubate
exudates1636623exudates
exuviae1744343exuvia_e
exuviated2044783exuviated
exuviates1945373exuviates
filiate10414233filiate
foliate10513533foliate
helpmate1545603helpmate
herniate1148113herniate
labiate91313573labiate
lapidate1157903lapidate
mediate103415213mediate
muriate9313363muriate
obviate1235783obviate
opiated1039483_opiated
opiates9312143_opiates
oppilate1245863oppilate
oxalate1457623oxalate
oxidate1537023oxidate
pate65350463__p_ate
pirate82322883__pirate
piste75824603__piste
plate74635113__plate
prate75135983__prate
pupate104213123pup_ate
radiate83416313radiate
replate93420053replate
respite9513033respi_te
satiate7315403satiate
septate9511873septate
seriate73722473seriate
sopite84917713sopi_te
spate74731583_sp_ate
spicate113214193_spicate
spinate93114813_spinate
spite75430663_spi_te
striate74218953striate
supinate10310313supinate
template1238433template
update93810293_update
uprate83916543_uprate
variate101316433variate
vitiate103412953vitiate

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.406440125.6
2DLD Change Limit1340271665.75023309.0
3Display Results1661660.0632634.9
 (SQL Overall)1786911666.21928733.1
 
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.