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 “alliterates” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
alliterates1110625(None) 
aliterates101510751a_literates
alliterate1086621alliterate_
alliterated1294691alliterated
illiterates11115651illiterates
aliterate91611332a_literate_
illiterate10125892illiterate_
literates91415652__literates
obliterates1345122obliterates
acierates11310813a_ci_erates
adulterates1244203adulterates
alienates9310683a_li_enates
aliteracies1355363a_literacies
alliterating1354273alliterating
alliteration1285163alliteration
alliterations1384553alliterations
alliterative1553873alliterative
altercates1247553a_l_tercates
alternates1047873a_l_ternates
arbitrates12117013arbit_rates
deliberates1446793deliberates
illiteracies1453303illiteracies
illiterately1552303illiterately
iterates81317823___iterates
liberates111012943__liberates
literate81216893__literate_
literatus9146823__literatus
nonliterates1255453nonliterates
obliterate1245073obliterate_
obliterated1453823obliterated
preliterates1455343preliterates
reiterates10412003_reiterates
subliterates1453663subliterates
ablegates1246794abl__egates
accelerates1554444accelerates
acierate10311814a_ci_erate_
acierated1238284a_ci_erated
adulterate1144764adulterate_
adulterated1353504adulterated
aerates74627494a____erates
agglomerates1691904agglomerates
agitates9310884a_git__ates
alginates10310124algi__nates
alienages1045974a_li_enages
alienate8311554a_li_enate_
alienated1047744a_li_enated
aliteracy1444334a_litera_cy
allergies10137784all__ergies
alleviates1344944all_eviates
alliteratively2062044alliteratively
allocates11410474all__ocates
allosteries1155394alloster_ies
allotropes1255594allot_ropes
alterants979104a_l_terants
altercate1147854a_l_tercate_
altercated1345454a_l_tercated
alterities10411044a_l_terities
alternate948114a_l_ternate_
alternated1145724a_l_ternated
ameerates1149064a__meerates
ameliorates1354244ameli_orates
amirates101114794a_mi__rates
antedates1048614a__ntedates
antiliterate1254104antiliterate_
antitrades1146524antit_rades
arbitrages13134534arbit_rages
arbitrate11137374arbit_rate_
arbitrated13125524arbit_rated
asperates11312554a__sperates
aspirates1139614aspi__rates
asseverates1452644asseverates
barbiturates16142414barbiturates
calibrates1446954cali_brates
cassiterites1452344cassiterites
citrates102315094__cit_rates
clathrates1545274_clathrates
deliberate1347124deliberate_
deliberated1545634deliberated
delineates1147124deline_ates
denitrates1169514denit_rates
desiderates1345814desiderates
deuterates1149084_deuterates
elaterites1048274_elaterites
electorates1347454electorates
exenterates1885374exenterates
filtrates1247734fil_t_rates
illiteracy1552624illitera_cy
illiterateness1472614illiterateness
illustrates1173364illustrates
incinerates1346034incinerates
iterate71119114___iterate_
iterated91213824___iterated
itinerates10126134_itinerates
lacerates112413774__lacerates
laterites9715054__laterites
liberate101113384__liberate_
liberated1299474__liberated
librates103412954__li_brates
literacies1248804__literacies
literals8312294__litera_ls
literately1345304__literately
literati81210804__literat_i
literatim11127184__literatim
literator948684__literator
literators1048104__literators
literatures1183654__literatures
litigates1048004__litigates
littermates1352864_littermates
lustrates939464_lust_rates
meliorates1288904meli_orates
militates11310884milit__ates
nitrates82516224__nit_rates
nonliterate1156194nonliterate_
obliterator1352784obliterator
obliterators1452604obliterators
palliates11311034palli___ates
palmitates1445454palmit__ates
palpitates1445304palpit__ates
preliterate1365954preliterate_
proliferates1753144proliferates
reiterate9412934_reiterate_
reiterated11410154_reiterated
semiliterates1552374semiliterates
subliterate1354104subliterate_
titrates82314664__tit_rates
tolerates9312124tol__erates
transliterates1462574transliterates
triturates1046764_triturates
ulcerates1148854_ul_cerates
unliberated1444254unliberated
valerates12310544val__erates
vizierates2243244vizi_erates
vociferates1982544vociferates

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit1488191338.47017570.1
3Display Results1331330.0632111.1
 (SQL Overall)1786911338.95319958.8
 
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.