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

114 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
asperated123931(None) 
asperate10312371asperate_
asperates11312551asperates
aspirated1247701aspirated
acerated113113982a_cerated
acierated1238282acierated
aerated85322372a__erated
aspersed11428292asper_sed
aspirate1039942aspirate_
aspirates1139612aspirates
asserted957902asser_ted
asteriated1177992asteriated
exasperated2153312exasperated
operated11512222_operated
aberrated1245873aberrated
abnegated1344163abnegated
acerate92818913a_cerate_
acerbated1465553a_cerbated
acetated112010683a_cetated
acierate10311813acierate_
acierates11310813acierates
adverted1336103adver_ted
aerate64830553a__erate_
aerates74627493a__erates
alerted82512223a_ler_ted
alienated1047743alienated
altercated1345453altercated
alternated1145723alternated
ameerate1039633ameerate_
ameerates1149063ameerates
amperage1347743amperage_
amperages1447683amperages
amputated1444463amputated
antedated1146703antedated
appealed1335603appe_aled
appeared1336143appe_ared
appeased1335793appe_ased
aspartate1144843aspartate_
aspartates1244673aspartates
asperating1349563asperating
asperges11318093asper_ges
asperities1249763asperities
asperity1347223asperit_y
asperse94210663asper_se_
asperser10408303asper_ser
asperses104111673asper_ses
asphalted1543113asphalted
aspirata1054993aspirat_a
aspiratae1143353aspiratae
aspirator1147283aspirator
aspired1068173aspir__ed
assegaied1142503assegaied
assented957513asse_nted
asserter877573asser_ter
asseverated1552143asseverated
assorted956603assor_ted
aurated83817793a__urated
auspicated1544303auspicated
averaged1356213a_veraged
averted112211613a_ver_ted
berated104422133__berated
caseated11310713cas_e_ated
casemated1446953cas_emated
castrated1239513cas_trated
cerated103922473__cerated
cooperated1567333cooperated
deaerated11311113deaerated
depurated1338183depurated
derated93623503__derated
desperate12410843desperate_
estreated1039553estreated
exasperate1954023exasperate_
exasperates2053783exasperates
experted1838053exper_ted
federated1438423federated
generated11310203generated
impetrated1544363impetrated
iterated91213823_iterated
lacerated122210673lacerated
liberated1299473liberated
macerated142010523macerated
moderated1388143moderated
numerated12177873numerated
operate9615733_operate_
operates10515413_operates
pirated102515613__pirated
prated94924923__p_rated
reoperated1348153reoperated
repeated113117443repe_ated
saponated1245733saponated
saturated1038993saturated
seated75131063_s_e_ated
sedated93714353_s_edated
separated1237713separated
seriated92717023_s_eriated
serrated92513433_serrated
speaned103411523_spe_aned
speared104314423_spe_ared
speciated14207543_speciated
spectated14236593_spectated
spermatid1448043_spermatid
spicated13309903_spicated
spiraled1137733_spiraled
spirited1148973_spirited
spirted103913073_spir_ted
sported104015433_spor_ted
sprayed13398903_sp_rayed
spurted103111973_spur_ted
sweated113411543_swe_ated
tolerated1049123tolerated
ulcerated1247743ulcerated
unaspirated1444243unaspirated
uprated103213323_up_rated
venerated1339953venerated

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411147.50019818.8
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.96922423.3
 
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.