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

129 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
interlineation145540(None) 
interlineations1554541interlineations
interanimation16135993interanimation
intergeneration1673393intergeneration
delineation1247764__de_lineation
determination1657644determin_ation
extermination2275744extermin_ation
incardination1655034incardin_ation
inclination1349734in__clin_ation
indetermination1863134indetermin_ation
insemination1446984inse_min_ation
intellection1466164inte_l_lection
inteneration1248624inte___neration
interanimations17115174interanimations
intercalation1557084inter_calation
interception1649374inter__ception
interconnection1963124interconnection
interdiction1568144interdi__ction
interdigitation1763144interdigitation
intergradation16114094intergradation
interjection2198924inter__jection
interlinear11145694interlinea___r
interlinearly1663144interlinea_rly
interlinears12144584interlinea__rs
intermediation17105214intermediation
internalization2455744internali_zation
interpellation1665614interpellation
interpolation1558554inter_polation
interpretation16115864interpretation
interrelation1358734inter_relation
interrogation1457864inter_rogation
intersection14610184inter__section
interstation12410414inter__station
intervention1568384inter__vention
intervisitation1862854intervisitation
termination131311164__termin_ation
winterization25137804winter_i_zation
alternation1147625alter__n_ation
declination14411875__declin_ation
delineations1346765__de_lineations
deterioration14145285deter_ioration
determinations1766895determin_ations
energization2256495en_ergi_zation
eternization2158665_eterni_zation
exterminations2365125extermin_ations
germination14148975__germin_ation
idealization22410265i_deali_zation
impersonation1764225imperson_ation
incardinations1754415incardin_ations
incarnation1347465incar__n_ation
incineration1446285in___cineration
inclinations1448755in__clin_ations
incoordination17172935incoordin_ation
incrimination17145655incrimin_ation
indentation1248375inde___ntation
inebriation1357245in_ebri__ation
infuriation1448245infur_i__ation
ingurgitation1552905ingurgi_tation
initialization2395955initiali_zation
innervation1447445inner___vation
inseminations1546235inse_min_ations
insinuation11137265in___sinuation
integration121310495inte___gration
intellections1565385inte_l_lections
intelligential1572245intelligential
intenerations1347455inte___nerations
intensification2092765intensification
intention9412015inte___n__tion
interaction13411815inter___action
intercalations1655915inter_calations
interceptions1758155inter__ceptions
intercession14226425inter__cession
interconversion2072485interconversion
interdictions1667495interdi__ctions
interdiffusion21132075interdiffusion
interelectron1564135inter_electron
intergradations17123455intergradations
interiorization2464785interiorization
interjections2277985inter__jections
interleaving1676165interl__eaving
interleukin1554455interl__euki_n
interline91218005interline_____
interlined111211265interline____d
interliner101311155interline____r
interliners11138695interline___rs
interlines101116445interline____s
interlining1249135interlin___ing
interlinking1755055interlin__king
intermediations1894425intermediations
intermission1464645intermi__ssion
intermodulation1893065intermodulation
international1357665inter__n_ational
interneuron1154075inter__ne_uron
interpellations1774705interpellations
interpolations1657435inter_polations
interpopulation1963595interpopulation
interposition1586045inter_position
interpretations17134805interpretations
interrelations1457615inter_relations
interrogations1556815inter_rogations
interruption1466405inter__ruption
intersections1598955inter__sections
intersession12175795inter__session
interspersion1564385inter_spersion
interunion1046255inter_un___ion
interventions1657505inter__ventions
intimation12413035int___i_mation
intimidation1547365int_imi_dation
intinction1247785int___in_ction
intonation10410265int___on_ation
intoxication21156355int_oxi_cation
introjection2156205int_r_ojection
introspection1764625int_rospection
invagination1645645in_vagin_ation
invalidation1646035in_vali_dation
investigation1754085investi_gation
itemization2248325i_te_mi_zation
iteration9515035i_ter____ation
itineration1156325i_t___ineration
lateralization2367435laterali_zation
laterization21410675later_i_zation
lineation9310765_____lineation
literalization2397395literali_zation
mineralization2577645min_erali_zation
pretermination1854775pretermin_ation
sterilization2258845_sterilization
terminations14149755__termin_ations
underinflation1862385under_inflation
winterizations26157495winter_i_zations

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 Filter178691950240.1401276364.3
2DLD Change Limit950241297.06313453.8
3Display Results1291290.0961343.8
 (SQL Overall)1786911297.29924481.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.