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

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

117 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
mainlines113851(None) 
mainline1039861mainline_
mainlined1254351mainlined
mainliner1144671mainliner
mainliners1244001mainliners
airlines8312792_airlines
anilines8415142_anilines
hairlines1237132hairlines
mailings113011922mai_lings
mainlands1244692mainlands
malines93625602ma__lines
manliness111310122ma_nliness
marlines103818712ma_rlines
midlines112613332m_idlines
millines102718062m_illines
aiblins9311473_aiblin_s
airline7315033_airline_
airliner836953_airliner
airliners945983_airliners
alines65735223_a__lines
amidines113010853ami_dines
aniline7418473_aniline_
anilins7416793_anilin_s
bailies94120203bai_li_es
balklines1536743balklines
baselines1138603baselines
canines93724033ca_n_ines
carlines103521643ca_rlines
crinolines1246733crinolines
dailies84219263dai_li_es
dailiness1038673dai_liness
dainties9312403dainti_es
daintiness1145963daintiness
datelines1088853datelines
eanlings9128473ea_nlings
failings123811013fai_lings
fanzines2036913fa_nzines
gainlier965673gainli_er
gainliest1037133gainli_est
gantlines1039333gantlines
gasolines1047483gasolines
hairline1137873hairline_
hiplines13310593_hiplines
inclines10313143__inclines
intines7921113__intines
jawlines18126363ja_wlines
kainites1238793kain_ites
kaolines1239293ka_olines
landlines1039763landlines
lanolines939983lanolines
machines15312893ma_chines
madeleines1343613madeleines
magazines2145633magazines
maidenliness1552083maidenliness
mailes84329113mai_l__es
mailing102923343mai_lin_g
mainland1145213mainlan_d
mainlander1352973mainlander
mainlanders1462503mainlanders
mainlining1343873mainlining
maintained1343853maintained
maintainer1243513maintainer
maintainers1352833maintainers
maintains1167103maintain_s
maiolicas1343973maiolicas
malices114316623ma__lices
maline84529083ma__line_
mallings113413093ma_llings
mandolines1347103mandolines
manginess122010413ma_nginess
manikins14189723manikin_s
manilles102312603manil_les
manlier92414023ma_nli_er
manliest102314943ma_nli_est
manlike133012783ma_nlike_
mannites10312613ma_nnites
mantises10317923ma_ntises
mantlings12207233mantlings
marblings14225543marblings
marines93928013ma__rines
marline93320953ma_rline_
marlings113713493ma_rlings
marlins93420473ma_rlin_s
marlites103415263ma_rlites
masculines1445513masculines
maundies1137853maundi_es
mayflies1644913mayfli_es
meinies92516073mein_i_es
midline102315103m_idline_
midlives14287463m_idlives
millimes122411373m_illimes
milline92519113m_illine_
milliner102811863m_illiner
milliners11289953m_illiners
millings113712583m_illings
minings103912073m_in_ings
minnies93617363m_inni_es
mislies92922283m_isli_es
mislikes143311833m_islikes
mislives132912153m_islives
myelines1337123m_yelines
paintings12327093paintings
quinines172410203quin_ines
quinolines1964703quinolines
railings93412153rai_lings
raininess949273rain_iness
ratlines83815293ra_tlines
sailings93513253sai_lings
saintliness1144153saintliness
salines74029413sa__lines
sanidines1048043sanidines
taglines92210833ta_glines
tailings93211673tai_lings
tapelines1138463tapelines
valines104520213va__lines
vaselines1246713vaselines
waistlines1343893waistlines

Search took 7 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411176.37623312.6
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.85826055.8
 
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.