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

97 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
inertia741020(None) 
inertiae8411471inertiae
inertial8411721inertial
inertias8410381inertias
anergia847362anergia
inedita846792inedita
inert53234372inert__
inertly1038542inertly
inerts64517022inert_s
intertie8317612intertie
invertin11910232invertin
amentia9310153amentia
anemia82613573ane_mia
anergias947173anergias
anergic1048103anergic
aneroid8314003aneroid
anuria6313123anur_ia
bertha11429173_bertha
ceria75125353_cer_ia
cineraria1145113cineraria
cinerin9313823ciner_in
dineric10310973diner_ic
emerita938713emerita
energid948303energid
entia5318203__entia
feria85922713_fer_ia
fingertip1572733fingertip
hernia9312293_hernia
identic1038043identic
ignatia846133ignatia
ileitis738063ileitis
imperia1148423imper_ia
indicia1046983indicia
indri6310793indr_i_
indris7311963indr_is
indusia845653indusia
inearth1037043ineart_h
inearths1144933inearths
inept73622153inept__
ineptly1245073ineptly
inertially1349333inertially
infertile1248673infertile
infra838643infr__a
ingesta8357863ingest_a
ingrain839523ingrain
inherit10312973inher_it
inherits11310103inherits
inia45024703in___ia
initial7311883in_itial
insert64325253insert__
inserted92413053inserted
inserter82312133inserter
inserting10914243inserting
insertion9410593insertion
inserts74013993insert_s
instil61111383in_stil
intarsia845763intarsia
interim9912873inter_im
intermit101213593intermit
intermix17156873intermix
intertidal1147713intertidal
interties9320333interties
intertill9410423intertill
intertrial1049513intertrial
inti46626083in__ti_
intima81910033in__tima
intis55121643in__tis
introit7414533introit
inverity1447963inverity
invert94120083invert__
inverted122312163inverted
inverter112411073inverter
inverting131013223inverting
invertins12911023invertins
invertor11238973invertor
inverts103211953invert_s
kerria10339913_kerria
kinetic13209173kine_tic
kinetin11248263kine_tin
minutia946423min_utia
nereid7312923_nereid
nereis6315343_nereis
neritic91314333_neritic
nerts55924983_nert_s
nertz145117453_nert_z
noria55722183_nor_ia
nutria639913_nutria
overtip1238193overtip
pereia85217983_pereia
pineta85815563pine_t_a
retia55326113_re_tia
shortia1048193shortia
synergia1243873synergia
terbia8311153_terbia
tertial7313863_tertial
tertian7511193_tertian
unerotic1049193unerotic

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit134027976.65620136.3
3Display Results97970.0303233.3
 (SQL Overall)178691977.09225196.1
 
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.