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

144 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
glassine932931(None) 
glassie8329491glassi_e
glassines10278041glassines
glassing10329971glassing
cassine93817282_cassine
classing113211792classing
gassing94216332g_assing
glassier9289082glassier
glassies94012272glassies
glassily1235462glassily
glassiness11245992glassiness
glassmen1145392glassmen
glossina9275542glossina
glossing10278882glossing
grassing103311972grassing
lassie64917742_lassi_e
alanine7316863ala_nine
amassing1138003amassing
arsine64021043__arsine
assize1538633__assize
bassinet10312843_bassinet
biassing11307263biassing
blastie92411393blasti_e
blasting114013433blasting
blessing1137593blessing
blissing1136873blissing
brassie93411523brassi_e
brassing112612303brassing
cassene93111543_cassene
cassina94113163_cassina
cassines103116613_cassines
cassino93512433_cassino
clashing143812193clashing
clasping133310263clasping
classic113710113classi_c
classico12386303classico
classics12418873classics
classier10359083classier
classify1644693classify
classily1336623classily
classiness12196313classiness
classis93712723classi_s
classism12407173classism
classist104010383classist
classon937693classon_
classons1037703classons
dassie74615573_dassi_e
eglantine1044973eglantine
elaphine1346113elaphine
elapine9310673ela_pine
elapsing1146713elapsing
elastin72611843elastin_
elastins82111743elastins
fascine12510583_fascine
flashing153711553flashing
flatline11298923flatline
flavine1338453fla_vine
flossie10337443flossi_e
flossing12247903flossing
galantine1047333galantine
gamine94620153g_a_mine
gashing125119233g_ashing
gaskin113610583g_askin_
gasking134415913g_asking
gaskins123510773g_askins
gasoline938523g_asoline
gasping113714363g_asping
gassier83812573g_assier
gassily1137813g_assily
gassiness10268313g_assiness
gassings10438403g_assings
gasting95022763g_asting
gawsie1038463g_awsi_e
gelatine93213313gela_tine
glaceing1236533glaceing
gladding1236303gladding
gladsome1244253gladsome
gladstone1144633gladstone
glaire74411303gla__ire
glairing1047283glairing
glaive10357933gla__ive
glancing1247063glancing
glaring93714883gla_ring
glass65518133glass___
glassed93710433glass_ed
glasses84414273glass_es
glassful12113563glassful
glassiest10279253glassiest
glassman1145183glassman
glassware1343223glassware
glassy10527753glass__y
glazing183611003gla_zing
gliadine1045403gliadine
glissade1043193glissade
glossae8477283gloss_ae
glosseme1144023glosseme
glossier9358203glossier
glossies93311253glossies
glossily1235093glossily
glossinas10214143glossinas
glossiness11284983glossiness
glycine1335713gl_ycine
gnashing1336423gnashing
gradine93317033gra_dine
grapline1138723grapline
grasping12348833grasping
grassier9349283grassier
grassily1236433grassily
grasslike1443693grasslike
gratine84719193gra_tine
grossing103111063grossing
guanine8810543gua_nine
guanosine1044303guanosine
guessing1036243guessing
gussie72910153g_ussi_e
jasmine1636643_jasmine
lapsing103511163_lapsing
larine63927043_la_rine
lasagne844063_lasagne
lashing114422893_lashing
lashins103915153_lashins
lasing74727983_la_sing
lassi56316853_lassi__
lassies74420103_lassies
lassis65216703_lassi_s
lassoing946383_lassoing
lasting84725243_lasting
latrine7715133_latrine
lauwine1036373_lauwine
lawine93316463_la_wine
lysine94210553_l_ysine
massing104318023_massing
massive12289773_massive
passing104318423_passing
passive12239593_passive
plashing143311063plashing
plasmin112410033plasmin_
plasmins12199413plasmins
plausive1344583plausive
quassin1645943quassin_
quassins1735793quassins
sassing84615553_sassing
slashing123713413slashing
tassie66017023_tassi_e

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621446.53322372.9
3Display Results1441440.0602400.0
 (SQL Overall)1786911447.01325480.0
 
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.