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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
aliterates10151075(None) 
aliterate91611331aliterate_
alliterates11106251alliterates
literates91415651_literates
acierates11310812aci_erates
alienates9310682ali_enates
aliteracies1355362aliteracies
alliterate1086622alliterate_
alliterated1294692alliterated
altercates1247552al_tercates
alternates1047872al_ternates
illiterates11115652illiterates
iterates81317822__iterates
liberates111012942_liberates
literate81216892_literate_
literatus9146822_literatus
obliterates1345122obliterates
reiterates10412002reiterates
acierate10311813aci_erate_
acierated1238283aci_erated
adulterates1244203adulterates
aerates74627493a___erates
agitates9310883agit__ates
alienages1045973ali_enages
alienate8311553ali_enate_
alienated1047743ali_enated
aliteracy1444333alitera_cy
alterants979103al_terants
altercate1147853al_tercate_
altercated1345453al_tercated
alterities10411043al_terities
alternate948113al_ternate_
alternated1145723al_ternated
ameerates1149063a_meerates
amirates101114793ami__rates
antedates1048613a_ntedates
arbitrates12117013arbit_rates
asperates11312553a_sperates
calibrates1446953cali_brates
citrates102315093_cit_rates
clathrates1545273clathrates
deliberates1446793deliberates
deuterates1149083deuterates
elaterites1048273elaterites
filtrates1247733filt_rates
illiterate10125893illiterate_
iterate71119113__iterate_
iterated91213823__iterated
itinerates10126133itinerates
lacerates112413773_lacerates
laterites9715053_laterites
liberate101113383_liberate_
liberated1299473_liberated
librates103412953_li_brates
literacies1248803_literacies
literals8312293_litera_ls
literately1345303_literately
literati81210803_literat_i
literatim11127183_literatim
literator948683_literator
literators1048103_literators
literatures1183653_literatures
litigates1048003_litigates
littermates1352863_littermates
nitrates82516223_nit_rates
nonliterates1255453nonliterates
obliterate1245073obliterate_
obliterated1453823obliterated
preliterates1455343preliterates
reiterate9412933reiterate_
reiterated11410153reiterated
subliterates1453663subliterates
titrates82314663_tit_rates
triturates1046763triturates
ulcerates1148853ul_cerates
valerates12310543val__erates

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 Filter1786911406030.423422437.4
2DLD Change Limit140603765.78024325.8
3Display Results76760.0461652.2
 (SQL Overall)178691766.24928595.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.