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 “intergalactic” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 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
intergalactic186234(None) 
intragalactic1871262intragalactic
extragalactic2571684extragalactic
interallelic1462264inter_allelic
intercalate13117704intercala_t_e
intercalated1596324intercala_ted
intercalates14117264intercala_tes
intercalating1656504intercala_ting
intercalation1557084intercala_tion
interglacial1554034interg_lacial
intervallic1653384interval__lic
metagalactic1961514met_agalactic
galactic13106555_____galactic
imperialistic1962945imperialistic
inelastic1146465in_e___lastic
integralities1495515integral_ities
integrality1554915integral_it_y
interact10316475inter___act__
interacted13411215inter___acted
interacting14411715inter___acting
interaction13411815inter___action
interactive1659635inter___active
interacts11312125inter___act_s
interatomic1553845inter_a_tomic
intercalary1654735intercala__ry
intercalations1655915intercala_tions
interdialectal1761585interdialectal
intergeneric1563915interg_eneric
interglacials1662555interg_lacials
intergradation16114095intergrada_tion
intergraft1446175interg_raft__
intergrafted1753945interg_rafted
intergrafting1854145interg_rafting
intergrafts1544415interg_raft_s
interlace11311915inter__lac__e
interlaced1349245inter__lac_ed
interlaces12412055inter__lac_es
interlacing1449055inter__lacing
interlaid1049355inter__la__id
intermetallic1762845intermetallic
intermitotic1653115inter_mitotic
internalities1358635internal_ities
internality1448685internal_it_y
interoceanic1653875interocea_nic
interpandemic2071395interpandemic
interplant12119575inter_plant__
interplanted1545055inter_planted
interplanting1655345inter_planting
interplants13116755inter_plant_s
interpolate1369335interpola_t_e
interpolated1547485interpola_ted
interpolates1448575interpola_tes
interpolating1657795interpola_ting
interpolation1558555interpola_tion
interpolative1865665interpola_tive
interpolator1455765interpola_tor
interpsychic2481275inter_psychic
interrelate11188975interrela_t_e
interrelated13167465interrela_ted
interrelates12148075interrela_tes
interrelating1457295interrela_ting
interrelation1358735interrela_tion
interscholastic2215865interscholastic
intervocalic1962945intervoca_lic
literalistic1454415liter_alistic
materialistic1774015materialistic
paternalistic1753265paternalistic
stereotactic1662685_stereotactic

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 Filter1786911247900.390458182.1
2DLD Change Limit124790689.12613674.1
3Display Results68680.0461478.3
 (SQL Overall)178691689.56218687.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.