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

93 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
gasolines104748(None) 
gasolenes1045821gasolenes
gasoline938521gasoline_
baselines1138602baselines
gantlines1039332gantlines
gasogenes1145722gasogenes
gasolene945552gasolene_
gasolier935832gasoli_er
gasoliers1044202gasoliers
gasolinic1243512gasolinic
isolines8312302_isolines
kaolines1239292ka_olines
lanolines939982lanolines
vaselines1246712vaselines
airlines8312793_airlines
alines65735223_a__lines
anilines8415143_anilines
apolunes1045293_apolunes
balklines1536743balklines
baseline10310753baseline_
baseliner1144743baseliner
baseliners1243863baseliners
bustlines11207353bustlines
carlines103521643ca_rlines
cassines103116613cas_sines
cholines132214493_cholines
coastlines12125333coastlines
cosmolines1445703cosmolines
datelines1088853datelines
fascines13310143fas_cines
fishlines15246843fishlines
gadflies1334733gadfli_es
gadolinites1351913gadolinites
gallies84122713ga_lli_es
gamines103618463ga__mines
gantline9410903gantline_
gaoling93314653ga_olin_g
gaposises1245523gaposises
gasalier936443gasali_er
gasaliers1044513gasaliers
gaselier946963gaseli_er
gaseliers1044923gaseliers
gasifies1238693gasifi_es
gaskings14427473gas_kings
gaskins123510773gas_kin_s
gasogene1045303gasogene_
gassiness10268313gas_siness
gassings10438403gas_sings
gastrins9310123gastrin_s
gazogenes2043693gazogenes
ghastliness1542643ghastliness
glassines10278043glas_sines
goslings10297553gos_lings
graplines1237353graplines
guanosines1143633guanosines
gumlines11238573g_umlines
guylines12236943g_uylines
hairlines1237133hairlines
haloclines1544213haloclines
isoclines1146223_isoclines
isoline7314013_isoline_
jasmines1736623jas_mines
jawlines18126363ja_wlines
kalsomines1643053kalsomines
kaoline11310143ka_oline_
kaolins1139363ka_olin_s
landlines1039763landlines
lanoline8311953lanoline_
lanolins8310533lanolin_s
mainlines1138513mainlines
malines93625603ma__lines
mandolines1347103mandolines
marlines103818713ma_rlines
masculines1445513masculines
masonites1149173masonites
nasalises948113nasalises
nasalizes1847233nasalizes
parvolines1585993parvolines
pemolines1348623pemolines
picolines1339623picolines
pisolites1149383pisolites
prolines102619693_prolines
ratlines83815293ra_tlines
salines74029413__salines
saponines1148043saponines
sozines16611263__sozines
splines94718893__splines
taborines11238983taborines
taglines92210833ta_glines
tapelines1138463tapelines
valines104520213va__lines
vaseline1138613vaseline_
waistlines1343893waistlines

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.1561145455.1
2DLD Change Limit148641937.47019898.4
3Display Results93930.0462021.7
 (SQL Overall)178691937.67223291.3
 
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.