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

140 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
grand7512269(None) 
brand85124491brand
gland75217711gland
grad66829861gra_d
gran56335011gran_
grana65722091grana
grands84218241grands
grans64832541grans
grant64840021grant
grind75917561grind
rand55839561_rand
aland65526412aland
and47244162__and
band76740902_band
bland85320452bland
brad75234342bra_d
braid85822262braid
bran65740382bran_
brands95118942brands
brandy124712062brandy
brank115222282brank
brans75437432brans
brant74742172brant
crane75331602crane
craned96121652craned
crank114819612crank
drank104816202drank
eland65820392eland
errand758792errand
franc104615412franc
frank124417512frank
fraud939862fraud
frond95316342frond
gad57556652g_a_d
gaed66031512g_aed
gan48060122g_an_
gane55145292g_ane
gang66031962g_ang
garland948702garland
garni6315702garni
gaud67025432g_aud
gerund836162gerund
giant65430592giant
glad65624012gla_d
glands85314402glands
glans65125832glans
goad66830982goa_d
gonad75216052gonad
gormand1157452gormand
graal64316502graal
grab75427612gra_b
grabs85719692grabs
grace85124542grace
graced105217902graced
grade75126092grade
graded94919552graded
grads75625752grads
graft95327202graft
grail64622872grail
grain65126252grain
grained93814272grained
grains74223092grains
grainy103914212grainy
gram77034582gra_m
grama85620282grama
gramp106218322gramp
grams85327312grams
grandad1038452grandad
grandam1139392grandam
grandee93115512grandee
grander93315872grander
grandly1238742grandly
grandma1136912grandma
grandpa1135412grandpa
grange83716202grange
granny104311162granny
granted94715102granted
grants73722472grants
granum9310912granum
grape84824662grape
graph115315612graph
grapy115416432grapy
grasp84814482grasp
grass66125202grass
grat55651282gra_t
grate64932882grate
grated84523922grated
grave94624872grave
graved114818812graved
gravid113710972gravid
gravy125512112gravy
gray85329892gra_y
grayed115415642grayed
grays95621332grays
graze155820052graze
grazed174115912grazed
greed75125692greed
grid65829612gr_id
grin55733722grin_
grinds84511842grinds
grins65427222grins
groan65618422groan_
groaned9259972groaned
groans74815062groans
ground82310272ground
grunt65523542grunt
guan55325582guan_
guano69213982guano
guans64419442guans
guard74415542guard
hand86833702_hand
land56337302_land
orad56031692ora_d
orang65119942orang
prang84820322prang
prank115019452prank
rad47662002_ra_d
raid55243072_raid
ran38266612_ran_
rands65930452_rands
randy95022082_randy
rang56939152_rang
rani46640102_rani
ranid66429332_ranid
rank85135522_rank
rant45864672_rant
rend56136572_rend
rind56535602_rind
rynd86414102_rynd
sand55338462_sand
stand65923282stand
strand74514822strand
trad55630912tra_d
trank96222422trank
tranq145416892tranq
trans54933042trans
trend64817452trend
viand9511072viand
wand85833872_wand
wrang94716112wrang

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.0931921408.6
2DLD Change Limit538001401.87628678.0
3Display Results1401400.0463043.5
 (SQL Overall)1786911402.01588680.4
 
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.