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

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

49 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
mainlined125435(None) 
mainline1039861mainline_
mainliner1144671mainliner
mainlines1138511mainlines
mainland1145212mainlan_d
mainliners1244002mainliners
maintained1343852maintained
airline7315033_airline_
airliner836953_airliner
airlines8312793_airlines
alined75221403_a__lined
aniline7418473_aniline_
anilines8415143_anilines
crinolined1343493crinolined
datelined1194713datelined
gainlier965673gainli_er
hairline1137873hairline_
hairlines1237133hairlines
inclined1138643__inclined
javelined2043323javelined
machined1637303ma_chined
mailed95326753mai_l__ed
mailing102923343mai_lin_g
mailings113011923mai_lings
mainlander1352973mainlander
mainlands1244693mainlands
mainlining1343873mainlining
maintainer1243513maintainer
maligned1285773ma__ligned
maline84529083ma__line_
malines93625603ma__lines
mankind1437773ma_nkin_d
manlier92414023ma_nli_er
manlike133012783ma_nlike_
manliness111310123ma_nliness
manned94418643ma_n__ned
margined1237743ma_rgined
marline93320953ma_rline_
marlines103818713ma_rlines
maxilliped2251553maxilliped
midline102315103m_idline_
midlines112613333m_idlines
milline92519113m_illine_
milliner102811863m_illiner
millines102718063m_illines
milliped1337383m_illiped
misliked15319513m_isliked
mislived14328783m_islived
unlined82515803__unlined

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 Filter1786911486410.420425454.8
2DLD Change Limit148641497.29620372.9
3Display Results49490.0163062.5
 (SQL Overall)178691497.73223110.6
 
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.