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

179 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
grab7542761(None) 
crab85727671crab
drab76226451drab
gab67155991g_ab
garb75332671garb
grabs85719691grabs
grad66829861grad
gram77034581gram
gran56335011gran
grat55651281grat
gray85329891gray
grub77220081grub
ab410674762__ab
arak86929572arak
arb510448422ar_b
barb85240062barb
blab86629132blab
bra56339462bra_
brad75234342brad
brae65639112brae
brag75229722brag
bran65740382bran
bras65746452bras
brat66055542brat
braw94829562braw
bray95232902bray
cab78355402_cab
carb85143162carb
crabs95421392crabs
crag75625302crag
cram85635492cram
crap85731842crap
craw97725262craw
crib86323582crib
dab67455562_dab
darb76033532darb
drabs85119672drabs
drag64825052drag
dram75832002dram
drat56247832drat
draw85623012draw
dray85428092dray
drib76823262drib
drub75920132drub
era35741502era_
eras45441502eras
fab87453132_fab
flab96628352flab
frae75330472frae
frag85126272frag
frap95925812frap
frat75648542frat
fray105428902fray
gabs76740422g_abs
gaby107123192g_aby
gad57556652g_ad
gae46457702g_ae
gag57753632g_ag
gal46055512g_al
gam67060062g_am
gamb96331842gamb
gan48060132g_an
gap67055612g_ap
gar47259902g_ar
garbs86321412garbs
gars55750742gars
gas48870252g_as
gat46880512g_at
gay76856492g_ay
gear55934972gear
gerah9315302gerah
ghat86435282ghat
gib66443532g_ib
glad65624012glad
glam76529342glam
glib79421442glib
glob76623392glob
gnar56021382gnar
gnat56034432gnat
gnaw86515742gnaw
goa47343802goa_
goad66830982goad
goal55829302goal
goas55239942goas
goat56250832goat
gob68950892g_ob
goral65125752goral
graal64316502graal
grabby14336182grabby
graben9419722graben
grace85124542grace
grade75126092grade
grads75625752grads
graft95327202graft
grail64622872grail
grain65126252grain
grama85620282grama
gramp106218322gramp
grams85327312grams
grana65722092grana
grand75122692grand
grans64832542grans
grant64840022grant
grape84824662grape
graph115315612graph
grapy115416432grapy
grasp84814482grasp
grass66125202grass
grate64932882grate
grave94624872grave
gravy125512112gravy
grays95621332grays
graze155820052graze
great66034242great
grebe85114942grebe
gree56641562gree
grew85620262grew
grey85624042grey
grid65829612grid
grig65424772grig
grim76929422grim
grin55733722grin
grip76127022grip
grit55247242grit
groan65618422groan
groat65531972groat
grog65923342grog
grok95819682grok
grot55942052grot
grow86127302grow
grubs86312602grubs
grue55825712grue
grum75625082grum
guan55325582guan
guar56923292guar
gyral94412782gyral
jab128444112_jab
kab97145852_kab
lab58864782_lab
nab56954922_nab
ora37250832ora_
orad56031692orad
oral47638122oral
orb55736862or_b
pram85733492pram
prao66229022prao
prat65952042prat
prau66529472prau
pray96331532pray
rad47662002_rad
rag45761322_rag
rah68052402_rah
rai37658222_rai
raj105740222_raj
ram56867272_ram
ran38266622_ran
rap56261962_rap
ras37575392_ras
rat37892742_rat
raw67252252_raw
rax108445722_rax
ray66361992_ray
reb55844962_reb
rib56848032_rib
rob56754302_rob
rub56342822_rub
sab56563202_sab
scab85926712scab
slab67133762slab
stab67329932stab
swab96825312swab
tab57460322_tab
trad55630912trad
tram67034552tram
trap67532802trap
tray77632592tray
urb55731112ur_b
wab87051832_wab
wrap96821972wrap

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298721791.08027659.3
3Display Results1791790.0305966.7
 (SQL Overall)1786911791.390128554.7
 
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.