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

126 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
belay10502152(None) 
belady12489931belady
belays114313851belays
belly104625491belly
delay94820631delay
relay84424671relay
allay85620392allay
balas76937212balas
baldy115518932baldy
balky145418242balky
bally105530102bally
balmy125217472balmy
bay89661642b__ay
bead75937922be_ad
beady114719922beady
beak106534382be_ak
beaky146118022beaky
beam86939232be_am
beamy126218572beamy
bean66443862be_an
bear66844642be_ar
beat66168302be_at
beau66137272be_au
becap114315052becap
bedlam1149272bedlam
beefy135313832beefy
beery105220122beery
beflag1265882beflag
began86319572began
begat86629722begat
beglad10138462beglad
beigy111110582beigy
bel57148462bel__
belaud939132belaud
belayed133610082belayed
belayer12339502belayer
belch124415502belch
beldam11410112beldam
beleap10410282beleap
belfry1435072belfry
belga8313232belga
belgas9311712belgas
belie75630382belie
bell66237182bel_l
belle75827832belle
bells76432162bells
belon73924112belon
below104617192below
bels66142492bel_s
belt65754032bel_t
belts75931162belts
beltway1564372beltway
bema85825252bema_
bemas96424282bemas
benday123810812benday
bendy115017252bendy
benny105217362benny
berry104521772berry
beta66234132beta_
betas75528762betas
betray111511442betray
bevy127115222be_vy
bewray14147732bewray
bey86645422be__y
bialy105119322bialy
bilby124912352bilby
bilgy114713712bilgy
billy105525362billy
blab86629132b_lab
blae66134642b_lae
blah98625062b_lah
blam86131702b_lam
blat66550952b_lat
blaw97026722b_law
bleak115915382bleak
blear75918682blear
bleary115112552bleary
bleat75737002bleat
bola66035562bola_
bolar75123472bolar
bolas74733762bolas
bray95232902b_ray
bulgy115214102bulgy
bulky146215572bulky
bully105124812bully
byelaw1444252byelaw
bylaw13408602bylaw
byplay1634192byplay
byway1647532byway
clay95927412_clay
decay114718482decay
delays104014052delays
delly96023872delly
deray95024182deray
eely77725212eel_y
elan46734242_elan
elmy95616792_elmy
felly114922802felly
flay106332802_flay
inlay85214322inlay
jelly154218252jelly
kelly124617022kelly
kelpy145110682kelpy
lay68865352__lay
mealy104422182mealy
melty104918362melty
nelly84618812nelly
onlay84212942onlay
play95928982_play
relax124817802relax
relays94316752relays
rely75428952rel_y
repay104818452repay
replay113412922replay
resay85320542resay
selah8319612selah
slay76436382_slay
splay105816042splay
tela45532972tela_
telae54323292telae
telly84920822telly
unlay84613702unlay
vealy115817772vealy
vela75725542vela_
velar85817632velar
welly114620012welly

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.296603685.8
2DLD Change Limit538001261.62633087.3
3Display Results1261260.0304200.0
 (SQL Overall)1786911261.95291542.5
 
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.