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

118 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
alliterated129469(None) 
alliterate1086621alliterate_
alliterates11106251alliterates
aliterate91611332a_literate_
aliterates101510752a_literates
illiterate10125892illiterate_
illiterates11115652illiterates
obliterated1453822obliterated
acierated1238283a_ci_erated
adulterated1353503adulterated
alienated1047743a_li_enated
alliterating1354273alliterating
alliteration1285163alliteration
alliterative1553873alliterative
altercated1345453a_l_tercated
alternated1145723a_l_ternated
arbitrated13125523arbit_rated
deliberated1545633deliberated
illiterately1552303illiterately
iterated91213823___iterated
liberated1299473__liberated
literate81216893__literate_
literates91415653__literates
obliterate1245073obliterate_
obliterates1345123obliterates
reiterated11410153_reiterated
unliberated1444253unliberated
accelerated1653944accelerated
acerated113113984a___cerated
acierate10311814a_ci_erate_
acierates11310814a_ci_erates
adulterate1144764adulterate_
adulterates1244204adulterates
aerated85322374a____erated
agglomerated1791614agglomerated
agitated1038414a_git__ated
alerted82512224a_l__er_ted
alienate8311554a_li_enate_
alienates9310684a_li_enates
alimented1245314a_lime_nted
aliteracies1355364a_literacies
aliteracy1444334a_litera_cy
alleviated1443964all_eviated
alliterations1384554alliterations
alliteratively2062044alliteratively
allocated1248094all__ocated
allografted1652114all_ografted
allotted986874allot___ted
altercate1147854a_l_tercate_
altercates1247554a_l_tercates
altered83215734a_l_ter__ed
alternate948114a_l_ternate_
alternates1047874a_l_ternates
ameliorated1453414ameli_orated
antedated1146704a__ntedated
antiliterate1254104antiliterate_
arbitraged14133104arbit_raged
arbitrate11137374arbit_rate_
arbitrates12117014arbit_rates
asperated1239314a__sperated
aspirated1247704aspi__rated
asseverated1552144asseverated
asteriated1177994a__steriated
calibrated1545644cali_brated
callipered1542864calliper__ed
citrated112712254__cit_rated
cultrated1248224cul_t_rated
deliberate1347124deliberate_
deliberates1446794deliberates
delineated1246244deline_ated
denitrated1298034denit_rated
desiderated1444944desiderated
deuterated1247534_deuterated
exenterated1964794exenterated
filtrated1345964fil_t_rated
illiteracies1453304illiteracies
illiteracy1552624illitera_cy
illustrated1262734illustrated
incinerated1445034incinerated
iterate71119114___iterate_
iterates81317824___iterates
itinerated11124934_itinerated
lacerated122210674__lacerated
lateraled1047454__lateraled
liberate101113384__liberate_
liberates111012944__liberates
librated113110314__li_brated
lineated9711064__line_ated
literately1345304__literately
literati81210804__literat_i
literatim11127184__literatim
literator948684__literator
literatus9146824__literatus
litigated1146564__litigated
loitered938184_loiter__ed
lustrated1037964_lust_rated
maltreated13125144mal_treated
meliorated1377004meli_orated
militated1248804milit__ated
nitrated92213154__nit_rated
nonliterate1156194nonliterate_
nonliterates1255454nonliterates
obliterator1352784obliterator
palliated1238494palli___ated
palpitated1544234palpit__ated
preliterate1365954preliterate_
preliterates1455344preliterates
proliferated1852364proliferated
reiterate9412934_reiterate_
reiterates10412004_reiterates
subliterate1354104subliterate_
subliterates1453664subliterates
titrated92611684__tit_rated
tolerated1049124tol__erated
transliterated1562084transliterated
triturated1145074_triturated
ulcerated1247744_ul_cerated
vociferated2082204vociferated

Search took 10 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.1561145455.1
2DLD Change Limit1488191189.03316475.0
3Display Results1181180.0631873.0
 (SQL Overall)1786911189.25219313.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.