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

225 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
gantline941090(None) 
gantlines1039331gantlines
aniline7418472_aniline
antlike11312072_antlike
bantling112612002bantling
buntline10198062buntline
gangling112411402gangling
gantlope1144412gantlope
gasoline938522gasoline
gentling1048452gentling
giantlike1443262giantlike
gnatlike1334742gnatlike
landline9311442landline
lanoline8311952lanoline
mantling112012612mantling
ratline74517802ra_tline
xanthine1847252xanthine
acanthine1474833acanthine
airline7315033_airline
aline57243153_a__line
aneling82719503_aneling
anglice1089213_anglice
angling92816043_angling
anguine839913_anguine
anilin6417793_anilin_
anilines8415143_anilines
anilins7416793_anilins
ankling122912063_ankling
anteing8312813_anteing
anticline11410703_anticline
antilife11410433_antilife
antimine10714753_antimine
anting75827023_ant_ing
antlion7310293_antlion
antlions839193_antlions
auntlike1234983auntlike
baculine1238983baculine
balkline1437973balkline
banalize191010933banalize
bantlings12216603bantlings
baseline10310753baseline
batlike133311883ba_tlike
battling113110493battling
beltline1036943beltline
buntlines11207153buntlines
bustline10208843bustline
canaling112016413canaling
canalise10816213canalise
canalize19914493canalize
candling122313873candling
canine83826703can__ine
cantina93417253cant_ina
canting104725903cant_ing
cantle84522153cantl__e
carline93923613ca_rline
castling11311233castling
catlike132712933ca_tlike
catlin83819083ca_tlin_
catling104819793ca_tling
catlins93818843ca_tlins
cauline92215603ca_uline
coastline1196363coastline
cutline92914543_cutline
dandling112511733dandling
dangling112611233dangling
dartling1039563dartling
dateline9810353dateline
dentine83320243dent_ine
eanling81416673ean_ling
eglantine1044973eglant_ine
entwine1039143_entwine
fanglike1636823fanglike
fanlike142610503fan_like
fanzine1937123fan_zine
fatlike142911193fa_tlike
fatling113815683fa_tling
flatline11298923flatline
frontline1245053frontline
gabbling14238073gabbling
gabling113514543ga_bling
gaggling10217463gaggling
gaiting93716583gait_ing
galantine1047313galant_ine
galling93921963ga_lling
gambling14218963gambling
gamelike1538033gamelike
gamine94620153ga__mine
ganging103216193gan_ging
gangland1145193gangland
ganglia946613gangli_a
ganglial1054663ganglial
gangliar1064123gangliar
gangliate1144493gangliate
ganglier1047603ganglier
ganglion1044393ganglion
ganglions1144063ganglions
gangrene1044363gangrene
gantelope1243403gantelope
gantlet83616243gantl_et
gantleted1144393gantleted
gantleting1243913gantleting
gantlets9308903gantlets
gantlopes1244283gantlopes
gantries91413783gantries
gaoling93314653ga_oling
garbling12249453garbling
gargling11239203gargling
gasolene945553gasolene
gasolines1047483gasolines
gasting95022763gast_ing
gastrin839833gastrin_
gastrins9310123gastrins
gatelike1337933gatelike
gating84826953ga_t_ing
gaveling133410163gaveling
geanticline1452173geanticline
gentile83515293gent_ile
gentle74014513gentl__e
gentrice1148813gentrice
genuine838373gen_uine
gnarling10217603gnarling
gnathite1244483gnathite
goatlike1346293goatlike
gonglike1455423gonglike
granting103514523grant_ing
granulite1046923granulite
grapline1138723grapline
gratine84719193grat_ine
gruntling1134263gruntling
guanidine1144043guanidine
guanine8810543guan__ine
guanosine1044303guanosine
gumline102810113g_umline
gunflint1245943gunflint
gutlike12308653g_utlike
guttling1037293guttling
guyline11258173g_uyline
hairline1137873hairline
handlike1639153handlike
handling132312713handling
hanting114124483hant_ing
hantle94318203hantl__e
hardline12310273hardline
hatlike143311713ha_tlike
hotline10712353_hotline
incline9314643_incline
intine61021983_int_ine
intwine1038513_intwine
jangling17249623jangling
jawline17137063ja_wline
kaoline11310143ka_oline
landlines1039763landlines
lanolin7310643lanolin_
lanolines939983lanolines
lanolins8310533lanolins
latrine7715123la_trine
longline938763longline
mainline1039863mainline
maline84529083ma__line
mandoline1248413mandoline
mangling122312623mangling
manlike133012783man_like
mantle84420923mantl__e
mantlings12207233mantlings
marline93320953ma_rline
mastlike1437863mastlike
oatlike113412403oa_tlike
online6315843_on_line
outline72321333_outline
paneling111013623paneling
pantalone1146833pantalone
pantie84326473pant_i_e
pantile93918483pant_ile
panting104025423pant_ing
patine85328123pa_t_ine
plantlike1544943plantlike
plotline1037643plotline
pontine92419053pont_ine
potline91015233_potline
ralline73518413ra_lline
rankling132610113rankling
ranting84025413rant_ing
ratine65131823ra_t_ine
ratlike113912353ra_tlike
ratlin64116523ra_tlin_
ratlines83815293ra_tlines
ratlins73615583ra_tlins
rattling92510873rattling
saintlike1344783saintlike
saline65132703sa__line
saltine75018563salt_ine
saltlike1237253saltlike
sandlike1339713sandlike
sandling102214413sandling
sanguine947633sanguine
sanidine939853sanidine
santolina946263santolina
scantling12107233scantling
setline7313923_setline
syncline1356073syncline
tagline82412453ta_gline
tangling101712543tangling
tanklike1136013tanklike
tantalise91210823tantalise
tantalite91010863tantalite
tantalize181010573tantalize
tapeline10310363tapeline
tattling9259473tattling
tentlike1236903tentlike
tontine72316143tont_ine
trotline8310023trotline
untwine1038623_untwine
valine94623093va__line
vaseline1138613vaseline
waistline1244173waistline
wangling132310993wangling
wanting114220173want_ing
wartlike1537043wartlike
wattling12258783wattling
wintling12249923wintling
xanthene1855553xanthene
xanthin1747043xanthin_
xanthines1966723xanthines
xanthins1846943xanthins
xanthone1847113xanthone

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.406440125.6
2DLD Change Limit1461622257.45319611.2
3Display Results2252250.0932419.4
 (SQL Overall)1786912257.95222471.2
 
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.