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

141 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
asperate1031237(None) 
asperated1239311asperated
asperates11312551asperates
aspirate1039941aspirate
acerate92818912a_cerate
acierate10311812acierate
aerate64830552a__erate
ameerate1039632ameerate
amperage1347742amperage
aspartate1144842aspartate
asperity1347222asperity
asperse94210662asper_se
aspirata1054992aspirata
aspiratae1143352aspiratae
aspirated1247702aspirated
aspirates1139612aspirates
desperate12410842desperate
exasperate1954022exasperate
operate9615732_operate
ablegate1147253ablegate
abnegate1144863abnegate
accurate12410663accurate
acerated113113983a_cerated
acerbate1247533a_cerbate
acervate1336983a_cervate
acetate92514753a_cetate
acierated1238283acierated
acierates11310813acierates
aerated85322373a__erated
aerates74627493a__erates
agemate101210583a_gemate
alienate8311553alienate
aliterate91611333aliterate
altercate1147853altercate
alternate948113alternate
ameerates1149063ameerates
amirate91115953a_mirate
amperages1447683amperages
ampere10514413amper__e
amputate1246263amputate
ankerite1248923ankerite
antedate949693antedate
apparat11711713apparat_
apparats1287093apparats
appease1137913appe_ase
appellate1346193appellate
appetite1258493appetite
apyrase1236363a_pyrase
arsenate81010483arsenate
ascorbate1344463ascorbate
asparkle1443843asparkle
aspartame1342743aspartame
aspartates1244673aspartates
aspect10612823aspe_ct_
aspects1146743aspe_cts
asper75520433asper___
asperating1349563asperating
asperges11318093asperges
asperities1249763asperities
aspers86220313asper__s
aspersed11428293aspersed
asperser10408303asperser
asperses104111673asperses
aspersive1445893aspersive
aspersor10336233aspersor
aspirant1048863aspirant
aspirants1145233aspirants
aspirator1147283aspirator
aspire8612123aspir__e
assert64922583asser_t_
asserted957903asser_ted
asserter877573asser_ter
asserts74311793asser_ts
asseverate1352693asseverate
asteriated1177993asteriated
aurate64426473a__urate
aureate72515283aure_ate
auspicate1345743auspicate
average1158853a_verage
baseplate13114873baseplate
berate84729023__berate
caseate9314783cas_e_ate
casemate1239843cas_emate
castrate10313863cas_trate
cerate84829463__cerate
cooperate13710143cooperate
copemate1439993copemate
deaerate9314173deaerate
depurate1139983depurate
derate74531233__derate
disparate1249053disparate
emeerate10410103emeerate
esperance1346693esperance
esterase849483esterase
exasperated2153313exasperated
exasperates2053783exasperates
federate12310883federate
generate9312903generate
impetrate1345723impetrate
iterate71119113_iterate
jasperware22181973jasperware
lacerate102214703lacerate
liberate101113383liberate
literate81216893literate
macerate122314073macerate
moderate11710993moderate
numerate101610393numerate
operated11512223_operated
operates10515413_operates
overate10620963_overate
pastorate11411173pastorate
pedate93117763__pedate
pirate82322883__pirate
prate75135983__p_rate
reoperate11410183reoperate
saturate8312813saturate
sedate73019813_s_edate
senate63725173_s_enate
separate10310783separate
septate9511873_septate
serape84818413_s_erape
seriate73722473_s_eriate
serrate73017543_serrate
spate74731583_sp__ate
speciate12209583_speciate
spectate12248833_spectate
spicate113214193_spicate
spinate93114813_spinate
sprat76635973_sp_rat_
sprats85819933_sp_rats
sprite84421773_sp_rite
stearate839723_stearate
supernate11313273supernate
temperate1348513temperate
tolerate8312323tolerate
ulcerate1039733ulcerate
underate9918603underate
uprate83916543_up_rate
valerate11311473valerate
venerate11312903venerate
yperite1249893_yperite

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.406440125.6
2DLD Change Limit1461621417.11020557.2
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.57923577.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.