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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
interstation1241041(None) 
infestation1447042infe_station
intersection14610182intersection
attestation1145183atte_station
contestation1448663conte_station
detestation1248363dete_station
incrustation14104433incrustation
indentation1248373inde_ntation
infestations1546623infe_stations
innervation1447443inner_vation
integration121310493inte_gration
inteneration1248623inteneration
interaction13411813inter_action
intercalation1557083intercalation
interception1649383interception
interdiction1568143interdiction
interjection2198923interjection
interpolation1558553interpolation
interpretation16115863interpretation
interrelation1358733interrelation
interrogation1457863interrogation
interruption1466403interruption
intersections1598953intersections
intersession12175813intersession
interstadial1354083interstadial
interstate10710973interstat__e
interstates11710203interstat_es
interstitial1255633interstitial
interstrain1155863interstrai_n
interstratify1963073interstratify
intervention1568383intervention
intervisitation1862853intervisitation
iteration9515033i_ter__ation
superstation14168623superstation
winterization25137803winterization
alteration10612904alter__ation
altercation1347014alter_cation
alternation1147624alter_nation
attestations1244464atte_stations
autorotation1255014autorotation
contestations1547734conte_stations
conversation1747804convers_ation
detestations1347584dete_stations
dissertation1366094disser_tation
encrustation14103394encrustation
enervation1369474en_er_vation
entertain947864enter_ta_i_n
forestation1447004fore_station
gestation10310664__ge_station
impartation15156104impar_tation
impersonation1764224impersonation
importation15147124impor_tation
incantation1347054in_cantation
incarnation1347464incar_nation
incitation12312224in__citation
incrustations15134284incrustations
incurvation1646984incur_vation
indentations1347884inde_ntations
indexation1846344inde__xation
induration11410614indur__ation
inebriation1357244in_ebriation
information16147714infor_mation
infuriation1448244infur_iation
ingestion10137484inge_s__tion
ingratiation1355804in_gratiation
ingurgitation1552904ingurgitation
inhabitation1754324inhabitation
innervations1546924inner_vations
insanitation12127184insanitation
insemination1446984insemination
insertion9410594inser___tion
inspissation1452374inspissation
integrations13129474inte_grations
intellection1466164intellection
intenerations1347454intenerations
intension948494intens___ion
intention9412014inte___ntion
interactions14410454inter_actions
interanimation16135994interanimation
interbasin1246854inter_basi_n
intercalations1655914intercalations
interceptions1758174interceptions
intercession14226444intercession
interchain1546634intercha_i_n
interdictions1667494interdictions
interdigitation1763144interdigitation
interfusion1464984inter_fusion
intergradation16114094intergradation
interjections2277984interjections
interlineation1455404interlineation
intermatting1547174intermatting
intermediation17105214intermediation
intermission1464654intermission
international1357664inter_national
interpellation1665614interpellation
interpolations1657434interpolations
interposition1586054interposition
interpretations17134804interpretations
interrelations1457614interrelations
interrogations1556814interrogations
interruptions1565724interruptions
intersecting1549714intersecting
intersectional16146234intersectional
intersessions13195284intersessions
interspacing1755054interspacing
interspersion1564394interspersion
interstadials1462534interstadials
interstage1176404intersta__ge
intersterile1254284intersterile
interstice1249594inters__tice
interunion1046254inter__union
interventions1657504interventions
intestacies1355304inte_stacies
intestate9159874inte_stat__e
intestates10159434inte_stat_es
intimation12413044int__imation
intimidation1547364intimidation
intonation10410264int__onation
intoxication21156354intoxication
intubation1247774int__ubation
inversion1247214invers___ion
investigation1754084inve_stigation
invitation13410024in__vitation
irritation1048974i__rritation
itemization2248324i_temization
iterations10413824i_ter__ations
laterization21410674laterization
literation10511414liter__ation
molestation1365964mole_station
nervation12610244_n_er_vation
nitration9313444nit_r__ation
ostentation1146954oste_ntation
outstation1046164out__station
protestation1456354prote_station
reinfestation1664254reinfe_station
restation9316914__re_station
sternutation1253964_sternutation
superstations15208144superstations
superstition14166874superstition
temptation1446374__temptation
understating1446544understating
winterizations26157494winterizations

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901427.34316994.4
3Display Results1421420.0801775.0
 (SQL Overall)1786911427.56323627.0
 
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.