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

62 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
mainliner114467(None) 
mainline1039861mainline_
mainlined1254351mainlined
mainliners1244001mainliners
mainlines1138511mainlines
airliner836952_airliner
gainlier965672gainli_er
mainlander1352972mainlander
maintainer1243512maintainer
manlier92414022ma_nli_er
milliner102811862m_illiner
airline7315033_airline_
airliners945983_airliners
airlines8312793_airlines
aliner65621983_a__liner
aniline7418473_aniline_
anilines8415143_anilines
bairnlier1142233bairnli_er
baseliner1144743baseliner
daintier937403dainti_er
hairline1137873hairline_
hairlines1237133hairlines
incliner1038513__incliner
inlier63615363__inli_er
mailer84724183mai_l__er
mailing102923343mai_lin_g
mailings113011923mai_lings
mainland1145213mainlan_d
mainlanders1462503mainlanders
mainlands1244693mainlands
mainlining1343873mainlining
maintained1343853maintained
maintainers1352833maintainers
maligner11115333ma__ligner
maline84529083ma__line_
malines93625603ma__lines
malinger11116533ma__linger
mangier104114063ma_ngi_er
manlike133012783ma_nlike_
manliness111310123ma_nliness
manner84020513ma_n__ner
marblier1256343marbli_er
mariner93315993ma__riner
marlier92614773ma_rli_er
marline93320953ma_rline_
marlines103818713ma_rlines
midlifer14215793m_idlifer
midline102315103m_idline_
midlines112613333m_idlines
millier93716703m_illi_er
milline92519113m_illine_
milliners11289953m_illiners
millinery14336103m_illinery
millines102718063m_illines
mincier113512473m_inci_er
mingier103815293m_ingi_er
miniver1238393m_in_iver
mintier93615993m_inti_er
misliker14319573m_isliker
paintier1048793painti_er
rainier71614263rain_i_er
saintlier954623saintli_er

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.423422437.4
2DLD Change Limit148641626.42023152.8
3Display Results62620.0331878.8
 (SQL Overall)178691626.87625987.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.