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

189 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
graplins114826(None) 
graplin1058441graplin_
grapline1138721grapline
graplines1237351graplines
caplins113515992_caplins
gradins93416232gra_dins
grains74223092gra__ins
graphics1645652graphics
graphing1538532graphing
grappling1544992grappling
grapplings1642322grapplings
gratins84119182gra_tins
grayling1338002grayling
graylings1433882graylings
gremlins1136052gremlins
ratlins73615582_ratlins
trapline10411862trapline
traplines11310372traplines
ablins8316193__ablins
agraphias1545073agraphias
brailing113514793brailing
brains85125473bra__ins
brasilins1146243brasilins
brawling143210043brawling
brazilins2043963brazilins
capelins12311133_capelins
caplin103216303_caplin_
carlins93921923_carlins
catlins93818843_catlins
chaplains1645743chaplains
complins14313113complins
craaling112711353craaling
cradling122411453cradling
craping124018713crap_ing
crappies142911163crappies
crapping153911453crapping
crawling143110513crawling
dragline1036843dragline
draglines1145993draglines
drains73719403dra__ins
draping114213353drap_ing
drawling13318673drawling
drumlins1144993drumlins
erepsins1037443erepsins
franklins1694763franklins
frapping16348103frapping
frauleins1242663frauleins
gabling113514543g_abling
gains65729513g_a__ins
galleins9258693g_alleins
gallies84122713g_allies
galling93921963g_alling
gallons83015953g_allons
gamins94420053g_a_mins
gaoling93314653g_aoling
gaping105618923g_ap_ing
gapless10349993g_apless
gapping134214783g_apping
garbling12249453garbling
gargling11239203gargling
garlics1038013g_arlics
gaskins123510773g_askins
gnarling10217603gnarling
goalies8316023goa_lies
goaling93515333goa_ling
goblins1039243g_oblins
graals74112913graal__s
grabbing14267313grabbing
grabbling1564583grabbling
grabens10367003gra_bens
graciles112511613graciles
gracilis11247033gracilis
gracing113216443gra_cing
gradin83517483gra_din_
gradine93317033gra_dine
gradines103615253gra_dines
grading103918713gra_ding
grafting13319623grafting
grails77518783gra__ils
grain65126253gra__in_
graining102813183graining
grainy103914213gra__iny
grannies9312613grannies
grans64832543gra___ns
granting103514523granting
grapelike1644663grapelike
graperies1239613graperies
grapes95123123grap__es
grapevine1543243grapevine
grapevines1642903grapevines
graphic1537353graphi_c
graphite1447153graphite
graphites1546823graphites
graphs124510153grap__hs
grapier103712603grap_ier
grapiest112211933grap_iest
grapiness1238253grap_iness
grapnels1134393grapnels
grappas12357103grap_pas
grapplers14274303grapplers
grapples13348123grapples
grasping12348833grasping
grassing103311973grassing
gratin74520583gra_tin_
gratine84719193gra_tine
grating93923183gra_ting
gratings103910763gra_tings
gratis74819243gra_ti_s
graveling1457383graveling
gravies11314093gra_vies
graving123114563gra_ving
gravlaks1642423gravlaks
graying124115883gra_ying
graylags1372983graylags
grazing183514553gra_zing
grazings19337263gra_zings
gremlin1035563gremlin_
griffins1544783griffins
grilling103811533grilling
grins65427223gr___ins
griping113012063grip_ing
gripping14277543gripping
griskins1335953griskins
groins73917203gr__oins
groping113313103grop_ing
growling1348163growling
grueling1078273grueling
gruelings1163763gruelings
gryphons1743963gryphons
guanins8810013gua_nins
harpins123615703harp_ins
hyalins13229273hya_lins
kaolins1139363_kaolins
kraaling13186663kraaling
kremlins1444483kremlins
lapins84520683_lap_ins
marlins93420473_marlins
napkins1336673_napkins
orpins83614163or_p_ins
papains11312363_papains
paulins9312613_paulins
poplins11313153_poplins
praline93019743pra_line
pralines102217723pra_lines
preplans1249613preplans
rabbins112811343_rabbins
raglans82410133_raglans
railing83325643_railing
railings93412153_railings
rains55140233_ra__ins
raisins72715343_raisins
rallies73823343_rallies
ralline73518413_ralline
raphias123511083_raphias
raphis114014323_raphi_s
rapids94913893_rap_ids
rapine85023083_rap_ine
rapines95120863_rap_ines
raping94829853_rap_ing
rapini84714683_rap_ini
rapping123619103_rapping
rappini11347573_rappini
ratlin64116523_ratlin_
ratline74517803_ratline
ratlines83815293_ratlines
ravelins113011603_ravelins
ravins94622563_ra_vins
rawins95617623_ra_wins
repins84924313_rep_ins
replans92814943_replans
replies94521043_replies
sapling103217863_sapling
saplings11269803_saplings
stapling112813153stapling
trailing92916093trailing
trains64725343tra__ins
tramline10311383tramline
tramlines1139843tramlines
trampling1436973trampling
trapans92812463trap_ans
traplike1437653traplike
trapping132911393trapping
trappings14265753trappings
trawling122710783trawling
tripling112712553tripling
tropins93116313trop_ins
trypsins1344903trypsins
wrapping16297623wrapping
wrappings17253713wrappings

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 Limit1461621897.26620115.9
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.76623009.4
 
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.