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

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

91 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
preliterate136595(None) 
preliterates1455341preliterates
preliterary1652692preliterary
proliferate1653402proliferate
reiterate9412932_re_iterate
aliterate91611333__aliterate
alliterate1086623_alliterate
deliberate1347123_deliberate
illiterate10125893_illiterate
literate81216893___literate
nonliterate1156193nonliterate
obliterate1245073_obliterate
postliterate1462523postliterate
presbyterate1961893presbyterate
preterite11613203pre__terite
proliferated1852363proliferated
proliferates1753143proliferates
reiterated11410153_re_iterated
reiterates10412003_re_iterates
subliterate1354103subliterate
adulterate1144764adul_terate
aliterates101510754__aliterates
alliterated1294694_alliterated
alliterates11106254_alliterates
ameliorate1244734ameli_orate
antiliterate1254104antiliterate
arbitrate11137374ar_bit_rate
chelicerae1752334chelicera_e
coelenterate1452704coelenterate
crepitate1385954crepit__ate
deliberated1545634_deliberated
deliberates1446794_deliberates
delineate1047794_deline_ate
denitrate10810534_denit_rate
desiderate1246274_desiderate
deuterate1049514_de_uterate
elaterite949724__elaterite
exenterate1795684exe_nterate
illiterates11115654_illiterates
iterate71119114____iterate
liberate101113384___liberate
literates91415654___literates
literati81210804___literati
meliorate1179484_meli_orate
nonliterates1255454nonliterates
obliterated1453824_obliterated
obliterates1345124_obliterates
peltate92013774p_el_t__ate
penetrate1149234p_enet_rate
perpetrate1476654perpet_rate
perseverate1663164perseverate
precipitate1755324precipitate
predebate1446164pre__debate
predicate14411784predi__cate
prelate9519694prel____ate
prelature1146264prelatur__e
prelocate13109524prel__ocate
premiere12249234premi_er__e
preponderate17193884preponderate
presbyterates2061684presbyterates
prestorage1344904pre_storage
preterit10315844pre__terit_
preterites12411794pre__terites
preterits11410964pre__terits
pretreat10311924pre__treat_
pretreated1347624pre__treated
pretreats1146934pre__treats
priorate10411734pr__i_orate
profiterole1651684profiterole
proliferative2162354proliferative
propitiate1447384propit_iate
prostrate11412484pr_ost_rate
rectorate11411364_re_ctorate
recuperate1445934_recuperate
redintegrate1463184_redintegrate
refrigerate1553624_refrigerate
regenerate1147964_regenerate
reintegrate1274944_reintegrate
reiterative1447534_re_iterative
relegate9311244_rel__egate
remigrate1249224_remi_grate
remunerate1266254_remunerate
reoperate11410184_re_operate
resituate948614_resit_uate
revibrate1446384_revi_brate
semiliterate1452784semiliterate
subliterates1453664subliterates
transliterate1363094transliterate
triliteral1053814trilitera_l
triliterals1153194triliterals
triturate947484tr__iturate

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.423422437.4
2DLD Change Limit148819918.72017066.4
3Display Results91910.0601516.7
 (SQL Overall)178691919.20319416.6
 
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.