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

112 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
obliterates134512(None) 
obliterate1245071obliterate_
obliterated1453821obliterated
aliterates101510752_aliterates
alliterates11106252alliterates
illiterates11115652illiterates
literates91415652__literates
nonliterates1255452nonliterates
obliterator1352782obliterator
obliterators1452602obliterators
subliterates1453662subliterates
aliterate91611333_aliterate_
alliterate1086623alliterate_
alliterated1294693alliterated
deliberates1446793deliberates
illiterate10125893illiterate_
iterates81317823___iterates
liberates111012943__liberates
literate81216893__literate_
literatus9146823__literatus
nonliterate1156193nonliterate_
obligates12207853obli__gates
obliterating1553393obliterating
obliteration1453893obliteration
obliterations1553453obliterations
obliterative1753053obliterative
obturates1157003ob__turates
preliterates1455343preliterates
reiterates10412003_reiterates
subliterate1354103subliterate_
ablegates1246794abl__egates
acierates11310814_aci_erates
adulterates1244204adulterates
alienates9310684_ali_enates
aliteracies1355364_aliteracies
altercates1247554_al_tercates
alternates1047874_al_ternates
arbitrates12117014arbit_rates
berates94126874_b___erates
birthrates1545024_birthrates
biteplates1444154_b_iteplates
butyrates1446084_b_utyrates
calibrates1446954cali_brates
citrates102315094__cit_rates
clathrates1545274_clathrates
coelenterates1552854coelenterates
commiserates1853604commiserates
deliberate1347124deliberate_
deliberated1545634deliberated
delineates1147124deline_ates
denitrates1169514denit_rates
desiderates1345814desiderates
deuterates1149084_deuterates
elaterites1048274_elaterites
exenterates1885374exenterates
filtrates1247734fil_t_rates
illiteracies1453304illiteracies
illiterately1552304illiterately
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
meliorates1288904meli_orates
militates11310884milit__ates
nitrates82516224__nit_rates
obituaries1243344ob_ituaries
oblates91913244obl____ates
obligate11198304obli__gate_
obligated13186904obli__gated
obligatos12195064obli__gatos
obligees1143954oblige___es
obligers1134724obliger___s
obsecrates1444584ob_secrates
obturate1077774ob__turate_
obturated1245954ob__turated
obviates1345154obvi___ates
oleates7417834o_l__e_ates
olivenites1343334o_livenites
operates10515414o___perates
oubliettes1242894oubli_e_ttes
outrates82421374o__ut_rates
postliterate1462524postliterate_
preliterate1365954preliterate_
proliferates1753144proliferates
reiterate9412934_reiterate_
reiterated11410154_reiterated
semiliterates1552374semiliterates
subliteracies1782294subliteracies
subliteratures1661074subliteratures
titrates82314664__tit_rates
tolerates9312124tol__erates
triturates1046764_triturates
ulcerates1148854_ul_cerates
unliberated1444254unliberated
valerates12310544val__erates
vizierates2243244vizi_erates
vociferates1982544vociferates

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.406440125.6
2DLD Change Limit1488191129.37315877.4
3Display Results1121120.0631777.8
 (SQL Overall)1786911129.84218156.0
 
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.