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

90 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
herniates124733(None) 
herniate1148111herniate_
herniated1346011herniated
herniae1039042hernia_e_
hernias10310772hernia__s
kernites1269112kerni_tes
seriates82620672ser_iates
aerates74627493aer__ates
arenites8917103areni_tes
berates94126873ber__ates
bernicles1345403bernicles
bornites10310983borni_tes
cerates95428253cer__ates
cerites94823433cer_i_tes
craniates11310653craniates
derates84028893der__ates
derivates13310093derivates
derogates11310973derogates
deviates12312733de_viates
enates64026433_e_n_ates
eradiates102010783_eradiates
ergates8314493_er_gates
expiates17810213_expiates
ferrates113013423fer_rates
ferriages1345663ferriages
ferrites112312833ferri_tes
fornicates1545843fornicates
geminates12310043geminates
germinates1347763germinates
headgates1446383headgates
hebetates1446433hebetates
heinies102514543heini__es
helpmates1645513helpmates
henbanes1336573he_nbanes
henries102718283henri__es
herbages1437093her_bages
heriots10312063her_iot_s
heritages1346713heritages
hermitages1643903hermitages
hermits12312143hermi_t_s
hernia9312293hernia___
hernial10310433hernia__l
herniating1445983herniating
herniation1348443herniation
herniations1447403herniations
heroines112916573heroi_nes
heroizes202610983heroi_zes
herries104025073herri__es
hesitates1269793hesitates
hessites1138613hessi_tes
hibernates1544623hibern_ates
hornists11208833hornist_s
hornitos1145393horni_tos
kernite1159473kerni_te_
lenites7818443le_ni_tes
marinates112516383marinates
mediates112814063me_diates
muriates10312083mur_iates
neonates8310063neon_ates
penates93321603pe_n_ates
perennates1256763perennates
perlites10316363perli_tes
permeates13311773permeates
perniones1148593perniones
perorates11417023perorates
phenates13611583phe_n_ates
reanimates1247853reanimates
reradiates11178013reradiates
resinates9314763resinates
reunites8312473reuni_tes
senates73322613se_n_ates
sensates8511143se_nsates
seriate73722473ser_iate_
seriated92717023ser_iated
serrates82617023ser_rates
sternites9310073sterni_tes
striates83417083str_iates
teniases838623te_niases
tergites9310543tergi_tes
terminates12410003terminates
termites10313693termi_tes
ternate7415483tern_ate_
thermites1438043thermi_tes
urinates8314133_urinates
variates111214983var_iates
verbiages1544683verbiages
veritates12310973veritates
verites103822263ver_i_tes
vernicles1446133vernicles
vernixes1836053verni_xes

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 Filter1786911486410.500357382.0
2DLD Change Limit148641908.62617231.7
3Display Results90900.0461956.5
 (SQL Overall)178691909.17219482.2
 
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.