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

82 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
certainties135376(None) 
uncertainties1592422uncertainties
captaincies1752653captaincies
certainer1146193certain__er
certainest1248863certain__est
certainty1443193certaint__y
certifies14310323cert_i_fies
acerbities1444974acer_bi_ties
betaines10313294be_tain__es
canities101519264c___anities
carnalities1348784carnalities
cecities12312044ce__ci_ties
celerities1289774celeri_ties
centauries1245534centa_uries
centralities1448624centralities
centricities1666404centricities
cerastes101111094cer_a_st_es
cerates95428254cer_a__t_es
ceratins102818734cer_a__tins
ceremonies1445784ceremon_ies
cerites94823434cer__i_t_es
certain92612214certain____
certainly1443154certain__ly
certified1548424cert_i_fied
certifier1447354cert_i_fier
certifiers1545154cert_i_fiers
certitudes1394494cert_itudes
cerusites1146524cerusi_t_es
cetanes9315134ce_ta_n__es
chanties132615804c__ha_nties
chieftaincies2361024chieftaincies
christies1449274chr__isties
circuities1446914circui_ties
corantoes1147654cor_a_ntoes
crannies10313014c_r_a_nnies
creatines112814434creatin__es
creatinines1344044creatinines
creativities1755784creativities
crinites10612764c_r__inites
crudities1247744c_rudi_ties
curtained1265504curtain__ed
curtaining1345534curtain_ing
curtainless1351934curtainless
curtains10259704curtain___s
dainties9312404___dainties
dentalities1249544dentalities
destinies10410844dest_in_ies
detainees10267154de_tain_ees
entities8617414_ent_i_ties
errancies1147964_erra_ncies
errantries1044944_erra_ntries
feracities1548714fer_acities
ferities111416724fer__i_ties
ferocities1548254feroci_ties
fertilities1448824fertilities
fortuities1346324fortui_ties
frailties1245854_fr_ailties
heredities1447224heredi_ties
keratinizes24104804keratinizes
keratitides16143954kerati_tides
keratitis1345874kerati_ti_s
keratitises15145154kerati_tises
mentalities13410024mentalities
mortalities1348424mortalities
pertained1238504pertain__ed
pertaining1347994pertain_ing
pertains102113424pertain___s
retinites9313504re_t_inites
retrainees1046394retrain_ees
serenities10411064sereni_ties
sergeanties1253744sergeanties
serjeanties1852644serjeanties
serosities10410824serosi_ties
serotinies1047444serotin_ies
suzerainties2152664suzer_ainties
tertiaries1047004tert_iaries
tetanies8513554te_ta_n_ies
urbanities1245334_urbanities
veracities1549504ver_acities
verdancies1645234verda_ncies
verities111418044ver__i_ties
warranties1344684warra_nties

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 Limit148819828.73317041.0
3Display Results82820.0461782.6
 (SQL Overall)178691829.20219418.7
 
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.