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

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

103 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
semiliterates155237(None) 
semiliterate1452781semiliterate_
subliterates1453663s_ubliterates
aliterates101510764___aliterates
alliterates11106264__alliterates
antiliterate1254104antiliterate_
debilitates1444474debilit__ates
deliberates1446794de__liberates
demilitarizes2583954demilitarizes
illiterates11115654__illiterates
literates91415654____literates
militates11310884__milit__ates
nonliterates1255454_nonliterates
obliterates1345124__obliterates
preliterates1455344_preliterates
reiterates10412004re___iterates
remilitarizes2474004remilitarizes
subliterate1354104s_ubliterate_
administrates1662395administrates
adulterates1244205_adul_terates
aliterate91611345___aliterate_
alliterate1086635__alliterate_
alliterated1294705__alliterated
ameliorates1354245_ameli_orates
commiserates1853605com_miserates
debilitate1344865debilit__ate_
debilitated1543815debilit__ated
decelerates1446795decel__erates
deciliters1345175deciliter___s
decilitres1344995decilit_r__es
deliberate1347125de__liberate_
deliberated1545635de__liberated
delineates1147125de__line_ates
demilitarize2484105demilitarize_
demilitarized2693175demilitarized
demonstrates15155605demonst_rates
denitrates1169515de__nit_rates
desiderates1345815de__siderates
deuterates1149085de___uterates
elaterites1048285_e__laterites
emeerates1149375_em___eerates
emigrates1248585_em__i_grates
emirates101214855_em__i__rates
equilibrates2352605equili_brates
eviscerates1652855_evi_scerates
exenterates1885375_e_xenterates
facilitates1644305facilit__ates
felicitates1644205felicit__ates
filtrates1247735__fil_t_rates
habilitates1673585habilit__ates
hemihydrates2461515hemi_hydrates
hemipterans1852865hemi_ptera_ns
humiliates1544625humili___ates
illiterate10125895__illiterate_
infiltrates1463945infil_t_rates
iterates81317825_____iterates
itinerates10126135___itinerates
liberates111012945____liberates
literate81216895____literate_
literatus9146825____literatus
meliorates1288905__meli_orates
micturates1456095__mi_cturates
militaries1249445__militar_ies
militarises1366505__militarises
militarizes2245935__militarizes
militate10311675__milit__ate_
militated1248805__milit__ated
millerites1247935__mil_lerites
nonliterate1156195_nonliterate_
obliterate1245075__obliterate_
obliterated1453825__obliterated
postliterate1462525postliterate_
preliterate1365955_preliterate_
proliferates1753145_proliferates
recalibrates1663465recali_brates
redintegrates1563095redi_ntegrates
refrigerates1653505re_frigerates
reinitiates1145425re_init_iates
reintegrates1374945re_i_ntegrates
reiterate9412935re___iterate_
reiterated11410155re___iterated
remigrates1348585rem__i_grates
remilitarize2384045remilitarize_
remilitarized2583105remilitarized
remonstrates14146055remonst_rates
remunerates1375945rem__unerates
selenates91611365se__l__enates
semicircles1751935semici__rcles
semideserts1451625semideser_t_s
semifitted1652855semifit___ted
semilethals1662215semilet_ha_ls
seminiferous1762145seminifer_ous
sempiternities1891235sem_piternities
senilities10312995senilit___ies
sequestrates2152485sequest_rates
silicates11311525s__ili__cates
similitudes1452065similit__udes
smelteries1246165s_mel_ter_ies
subliteracies1782295s_ubliteracies
subliteratures1661075s_ubliteratures
transliterates1462575transliterates
triliterals1153195_trilitera_ls
vizierates2243245__vizi_erates

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901038.61014493.6
3Display Results1031030.0631634.9
 (SQL Overall)1786911039.06319716.5
 
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.