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

113 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
gliadin93559(None) 
gliadine1045401gliadine
gliadins1035191gliadins
gliadines1144772gliadines
gliding103911842gli_ding
gradin83517482g_radin
alanin6317273al_anin
aliasing9310073aliasing
alizarin1745863alizarin
alkalin11178183alkalin
amidin94015673ami_din
avidin103510843avi_din
blading113615363bl_ading
blain75421793bl_a_in
blinding123210163blinding
diamin9312523_diamin
diazin1639163_diazin
elain55324703el_a_in
eliding93414343eli_ding
flavin1239303fl_avin
gadi66329723g__adi_
gadid85517383g__adid
gadis74825293g__adis
gaijin1445983gai_jin
gain56042163g__a_in
gamin84423003g__amin
gelatin83514733gelatin
giardia945563g_iardia
gilding103813003g_ilding
girding103611883g_irding
gittin72910553g_ittin
glacis94012133gl_acis
glad65624013gl_ad__
gladden10376313gladden
gladding1236303gladding
glade75121963gl_ad_e
glades84820343gl_ades
gladier93810993gl_adier
gladly11497933gl_adly
glads75620613gl_ad_s
glady105413943gl_ad_y
glaikit1244633glaikit
glair65313553gl_a_ir
glairing1047283glairing
glaring93714883gl_aring
glazing183611003gl_azing
gleaming12277933gleaming
glean65818203glea__n
gleaning10269323gleaning
glia56423153glia___
glial66715433glia__l
glias64618493glia__s
glide74521593gli_d_e
glided94513903gli_ded
glider84614263gli_der
glides84518863gli_des
gliming113310133gli_ming
glinting103210053glinting
glissading1342253glissading
glisten8418083glisten
glitzing1934973glitzing
gloaming12268013gloaming
gloating102611463gloating
globin9309723gl_obin
glonoin875673glonoin
glycin1235963gl_ycin
goading103112853g_oading
goliardic1351943goliardic
gonadic1177213gonadic
gradine93317033g_radine
grading103918713g_rading
gradins93416233g_radins
grain65126253g_ra_in
gratin74520583g_ratin
griding103014973gri_ding
griffin1434513griffin
grinding1139863grinding
griskin1236013griskin
guanin7610803g_uanin
guiding102911843gui_ding
guidon837373gui_don
iliad64613463iliad__
iliads7448673iliad_s
iodin64419353__iodin
laden65022193_l_aden
lading84227123_l_ading
ladino73615123_l_adino
lain46146283_l_a_in
lapin75222923_l_apin
layin84720333_l_ayin
leaden74515223_leaden
leading93419553_leading
lidding103611433_lidding
lignin74911193_lignin
linden7411453_linden
linin58025523_li_nin
lipin75518893_li_pin
loading94114613_loading
miladi938883miladi_
miladis1049823miladis
niacin8310223_niacin
paladin101011773paladin
plain74823303pl_a_in
pleading123011443pleading
slain54923573sl_a_in
slidden935153slidden
sliding93114553sli_ding
thiamin1236933thiamin
thiazin1945483thiazin
tolidin839243toli_din
triadic1037833triadic
triazin1638203triazin
xylidin1844333xyli_din

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271137.09318895.7
3Display Results1131130.0303766.7
 (SQL Overall)1786911137.27924548.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.