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 “grans” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

292 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
grans6483254(None) 
brans75437431brans
glans65125831glans
grabs85719691grabs
grads75625751grads
grains74223091grains
grams85327311grams
gran56335011gran_
grana65722091grana
grand75122691grand
grands84218241grands
grant64840021grant
grants73722471grants
grass66125201grass
grays95621331grays
grins65427221grins
groans74815061groans
guans64419441guans
trans54933041trans
alans55636172alans
araks94820882araks
azans146516882azans
bans66555132_bans
barns76335142barns
beans75734692beans
brads85528292brads
braes75735052braes
brags85625102brags
brains85125472brains
bran65740382bran_
brand85124492brand
brands95118942brands
brank115222282brank
branks124817382branks
brant74742172brant
brants85723052brants
bras65746452bra_s
brass75428022brass
brats75336012brats
brawns115614082brawns
braws106425192braws
brays106723112brays
brens75823362brens
brins75533972brins
burans85019302burans
cans65050842_cans
carns75937562carns
clans75031012clans
crabs95421392crabs
crags85622572crags
crams96229152crams
crane75331602crane
cranes84330752cranes
crank114819612crank
cranks125015312cranks
craps95328642craps
crass76328042crass
craws105723122craws
cyans105714812cyans
dans56748142_dans
darns66927892darns
deans66131392deans
drabs85119672drabs
drags75521112drags
drains73719402drains
drams86025832drams
drank104816202drank
drats66628372drats
draws95119372draws
drays95819772drays
earns55927562earns
elans55527752elans
eras45441502era_s
erns45428222er_ns
fans76247362_fans
flans85327972flans
frags96322162frags
franc104615412franc
francs114112192francs
frank124417512frank
franks134912732franks
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
frons86124042frons
furans94515952furans
gabs76740422g_abs
gads67843382g_ads
gaes56348032g_aes
gags66441062g_ags
gains65729512gains
gals57946502g_als
gams76648882g_ams
gan48060122g_an_
gane55145292g_ane
gang66031962g_ang
gangs76222572g_angs
gaps76042972g_aps
garbs86321412garbs
garni6315702garni
gars55750742g_ars
gas48870252g_a_s
gats56753442g_ats
gays87338022g_ays
gears64628692gears
gens55740072g_ens
gerahs1039412gerahs
germans1079462germans
ghats95818612ghats
giant65430592giant
giants74713502giants
gins55543952g_ins
girns64516802girns
girons75014372girons
glads75620612glads
glams85822932glams
gland75217712gland
glands85314402glands
glass65518132glass
gleans75014742gleans
glens66519852glens
gnars66718852gnars
gnats65217712gnats
gnaws96311142gnaws
goads77022852goads
goals65521292goals
goas55239942goa_s
goats65527302goats
gobans94412042gobans
goons65326772goons
gorals76917652gorals
gowans105512292gowans
gowns95115102gowns
graal64316502graal
graals74112912graals
grab75427612gra_b
grabens10367002grabens
grace85124542grace
graces94523492graces
grad66829862gra_d
grade75126092grade
grades84926312grades
gradins93416232gradins
gradus84411212gradus
graft95327202graft
grafts105013252grafts
grail64622872grail
grails77518782grails
grain65126252grain
grainy103914212grainy
gram77034582gra_m
grama85620282grama
gramas94317202gramas
gramp106218322gramp
gramps114114272gramps
grange83716202grange
granges93516522granges
granny104311162granny
granum9310912granum
grape84824662grape
grapes95123122grapes
graph115315612graph
graphs124510152graphs
grapy115416432grapy
grasp84814482grasp
grasps9489252grasps
grassy10619092grassy
grat55651282gra_t
grate64932882grate
grates75429882grates
gratins84119182gratins
gratis74819242gratis
grave94624872grave
graves104624002graves
gravy125512112gravy
gray85329892gra_y
graze155820052graze
grazes164519642grazes
greats76318392greats
greens75716872greens
grees65132472grees
greys96614852greys
grids75321392grids
grigs75318192grigs
grin55733722grin_
grind75917562grind
grinds84511842grinds
grips85520132grips
grits65529582grits
groan65618422groan_
groats74816652groats
grogs76319412grogs
groins73917202groins
groks105716122groks
gross65421692gross
grots65025852grots
grows95523922grows
grubs86312602grubs
grues65721962grues
grunt65523542grunt
grunts75511852grunts
guan55325582guan_
guano69213982guano
guanos73811992guanos
guars65021042guars
guns55533482g_uns
gyrons105511222gyrons
irons55324132irons
jeans126022112jeans
karns96624142karns
khans124615172khans
koans95818622koans
leans55536252leans
loans56026462loans
lorans65117602lorans
mans66354532_mans
means75831222means
moans74624362moans
naans55815252naans
nans46139392_nans
orals55826482orals
orang65119942orang
orangs74116032orangs
organs7912912organs
pans65855722_pans
peans75437642peans
pians75126962pians
plans75731272plans
prams96125512prams
prang84820322prang
prangs94816232prangs
prank115019452prank
pranks124814722pranks
praos74923562praos
prats76333392prats
praus74621752praus
prawns11509022prawns
prays105022432prays
pyrans11411062pyrans
rads56046602_rads
rags55448372_rags
rains55140232_rains
rais45252622_rais
rams65950772_rams
ran38266612_ran_
rand55839562_rand
rands65930452_rands
rang56939152_rang
rani46640102_rani
ranis55235832_ranis
rank85135522_rank
ranks95225732_ranks
rant45864672_rant
rants55935342_rants
raps66247732_raps
ras37575392_ra_s
rats46260372_rats
raws75238212_raws
rays77642352_rays
rins46153192_rins
roans54926442roans
runs46438072_runs
sans45153352_sans
sarans64224432sarans
scans74625102scans
spans74528732spans
swans84625012swans
tans46154812_tans
tarns56433952tarns
trains64725342trains
trams75327672trams
trank96222422trank
tranks104017762tranks
tranq145416892tranq
tranqs155210312tranqs
traps75727482traps
trass56226472trass
trays85623432trays
ulans54921302ulans
urns46323892ur_ns
vans76236722_vans
wans76452262_wans
warns87231002warns
weans85326742weans
wrang94716112wrang
wrangs104611912wrangs
wraps105617152wraps
wrens85016242wrens
yarns85621792yarns
yeans86624882yeans
yuans84613322yuans

Search took 3 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 Filter178691538000.1731032896.0
2DLD Change Limit538002922.21624278.0
3Display Results2922920.1102654.5
 (SQL Overall)1786912922.49971505.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.