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

65 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
gliadines114477(None) 
gliadine1045401gliadine_
gliadins1035191gliadin_s
gliadin935592gliadin__
gradines103615252g_radines
alanines8314803al_anines
aliasings1043653aliasings
alizarines1944663alizarines
almandines1344323almandines
amidines113010853ami_dines
bladings12337753bl_adings
blondines1246153blondines
diamines11311643_diamines
diazines1838713_diazines
flamines13311643fl_amines
flavines1437893fl_avines
gabardines1443073gabardines
gallamines1345493gallamines
gamines103618463g__amines
gelatines102910533gelatines
giddies103713363g_iddi_es
giddiness1234683g_iddiness
gildings11356973g_ildings
glacises1138503gl_acises
gladdens11364463gl_addens
glades84820343gl_ad__es
gladier93810993gl_adi_er
gladiest101710333gl_adi_est
gladness1036153gl_ad_ness
glaires84010133gl_a_ires
glaives11347833gl_a_ives
glariness1038553gl_ariness
glassines10278043glassines
glaziness1935753gl_aziness
glazings19325753gl_azings
gleanings11244643gleanings
glides84518863gli_d__es
gliding103911843gli_din_g
gloamings13254093gloamings
glutamines1343503glutamines
glycines1445083gl_ycines
gradine93317033g_radine_
gradins93416233g_radin_s
grenadines1245173grenadines
guanines989773g_uanines
iodines83616633__iodines
ladies75124883_l_adi_es
ladings93814133_l_adings
ladinos8389963_l_adinos
lawines103313563_l_awines
leadings103511243_leadings
liaises7311053_lia_ises
lianes63819323_lia__nes
lindanes939173_lindanes
lindies8416583_lindi_es
loadings10378383_loadings
miladies1139923miladi_es
olivines1137473oli_vines
pleadings13285543pleadings
thiamines1446383thiamines
thiazines2144643thiazines
tolidines1046883toli_dines
triazines1847543triazines
uridines989513uri_dines
xylidines2042993xyli_dines

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 Limit148641656.28323657.6
3Display Results65650.0302166.7
 (SQL Overall)178691656.73626527.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.