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

108 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
interplanted154505(None) 
interplant12119572interplant__
interplants13116752interplant_s
interplayed1745242interpla_yed
interpolated1547482interpola_ted
interacted13411213inter__acted
intercalated1596323intercalated
interchanged19103443interchanged
intergrafted1753943intergrafted
interlaced1349233inter_la_ced
interlapped1644093inter_lapped
interlarded1345233inter_larded
interlined111211263inter_lin_ed
interlinked1644843inter_linked
intermatted1476303inter_matted
interpellated1654583interpellated
interplanting1655343interplanting
interpleaded1654063interpleaded
interpled1239603interpl___ed
interpolate1369333interpola_te_
interpolates1448573interpola_tes
interpreted1458173interp_reted
interrelated13167463interrela_ted
overplanted1746233_overplanted
contemplated1954444contempla_ted
explanted1944974___explanted
fingerprinted2061024fingerprinted
hinterland1443474hinter_lan__d
implanted1475494i___mplanted
innervated1445474inner_va_ted
integrated1289294inte_gra_ted
intenerated1247014intenera_ted
interallied1246064interal_lied
intercalate13117704intercalate_
intercalates14117264intercalates
intercaste1249284inter_caste_
intercepted16157724inter_cepted
interchange17104584interchange_
interchanger1883464interchanger
interchanges1894264interchanges
interchannel1752534interchannel
interclan1148604interclan___
intercluster1453854intercluster
intercrater1349234intercra_ter
interdicted1546224inter_dicted
interested11410334inter__ested
interfaced1647944inter_fa_ced
interflowed1843954interfl_owed
intergraded1445634intergra_ded
interisland1253664interislan__d
interjected2146844inter_jected
interjoined1944944interjoin_ed
interknitted1752844interknitted
interknotted1762114interknotted
interlace11311914inter_la_ce_
interlaces12412054inter_la_ces
interlaid1049354inter_la__id
interlard1048454inter_la__rd
interlayer1346924inter_la_yer
interlayered1652714inter_layered
interleaved1545864inter_leaved
interlend10310114inter_len__d
interlent9416734inter_lent__
interline91218014inter_lin_e_
interliner101311154inter_lin_er
interlines101116454inter_lin_es
interlocked1854544inter_locked
interlooped1444354inter_looped
interloped1347634inter_l_oped
intermitted1476504inter_mitted
internalised13127044internalised
internalized22147454internalized
interned93016654inter___n_ed
interparty1546854interp_art_y
interpellate1455414interpellate_
interpellates1554874interpellates
interphase1545994interpha_se_
interphases1646154interpha_ses
interplanetary1961744interplanetary
interplay1447164interpla___y
interplaying1845514interplaying
interplays1545524interpla__ys
interplead1345604interpl__ead
interpleader1553784interpleader
interpoint12411884interpoint__
interpolator1455764interpola_tor
interposed1348024interp__osed
interpreter1348044interp_reter
interrelate11188974interrela_te_
interrelates12148074interrela_tes
interrogated1476374interrogated
interrupted1475294inter_rupted
intersected1448284inter_sected
interspaced1644534interspa_ced
interstate10710974intersta_te_
interstates11710204intersta_tes
intertwined1544594intertwin_ed
intertwisted16113064intertwisted
intervened14109064inter_ven_ed
interweaved1844744interwea_ved
intraplate1255724intrapla_te_
intreated10312664int_r_ea_ted
iterated91213824i_ter__a_ted
overplanned1744344_overplanned
replanted1248064__re_planted
underplayed1875024underpla_yed
unplanted1236854un___planted
untenanted1144454unte__nanted

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.406440125.6
2DLD Change Limit1247901087.39316879.5
3Display Results1081080.0601800.0
 (SQL Overall)1786911087.85922737.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.