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

130 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
grail6462287(None) 
brail75525551brail
drail65020971drail
frail85220211frail
graal64316501graal
grails77518781grails
grain65126251grain
rail46147761_rail
trail55126771trail
agnail739532agnail
ail37171042__ail
argil65116882argil
aril45843022ar_il
avail8313882avail
bail65042802_bail
braid85822262braid
brails84621292brails
brain76229382brain
brasil8713862brasil
brawl106217962brawl
brazil1779622brazil
broil74918222broil
craal74117752craal
crawl104916712crawl
derail74218812derail
drails74716952drails
drain65222892drain
drawl95516012drawl
email74715102email
engrail846262engrail
ervil8310302ervil
fail74840242_fail
flail85316182flail
frails93716472frails
frazil1847222frazil
gaily95020972g_aily
gain56042162g_ain
gait56150192g_ait
gal46055512g_a_l
gall56335992g_all
gaol56925412g_aol
gerbil938342gerbil
glair65313552glair
glial66715432glial
gnarl65115572gnarl
goal55829302goa_l
goral65125752gora_l
graals74112912graals
grab75427612gra_b
grabs85719692grabs
grace85124542grace
gracile102512602gracile
grad66829862gra_d
grade75126092grade
gradin83517482gradin
grads75625752grads
graft95327202graft
grains74223092grains
grainy103914212grainy
gram77034582gra_m
grama85620282grama
gramp106218322gramp
grams85327312grams
gran56335012gra_n
grana65722092grana
grand75122692grand
grans64832542grans
grant64840022grant
grape84824662grape
graph115315612graph
grapy115416432grapy
grasp84814482grasp
grass66125202grass
grat55651282gra_t
grate64932882grate
gratin74520582gratin
gratis74819242gratis
grave94624872grave
gravel105313822gravel
gravid113710982gravid
gravy125512112gravy
gray85329892gra_y
grayly13287962grayly
grays95621332grays
graze155820052graze
grid65829612gr_id
grig65424772gr_ig
grill64617892grill
grim76929422gr_im
grin55733722gr_in
grip76127022gr_ip
grit55247242gr_it
groin65521082groin
growl96115822growl
gruel66014742gruel
gyral94412782gyra_l
hail74839062_hail
jail115529092_jail
kail85131492_kail
kraal94511822kraal
krait94726772krait
mail65543452_mail
nail45838652_nail
oral47638122ora_l
pail66141832_pail
quail144314362quail
rai37658222_rai_
raia46638382_raia
raid55243072_raid
rails55937402_rails
rain46251732_rain
rais45252622_rais
rial45938092_rial
roil46235292_roil
sail45447162_sail
serail64222672serail
snail57020202snail
spail74921552spail
swail86217162swail
tail45443652_tail
traik95418202traik
trails64622512trails
train56529112train
trait56940842trait
trawl84915872trawl
trial54926352trial
uracil8311542uracil
urial54823022urial
vail75432552_vail
wail75238822_wail

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 Filter178691538000.313570897.8
2DLD Change Limit538001301.54634799.5
3Display Results1301300.0304333.3
 (SQL Overall)1786911301.88994595.6
 
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.