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

121 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
blunt7552502(None) 
blent76230951blent
bluet75631191bluet
blunts84512891blunts
blurt77625621blurt
brunt75728751brunt
bunt65850851b_unt
lunt46148841_lunt
abluent939622abluent
alant55742292alant
aunt46553652_aunt
bent67759912b_ent
bhut95425712bhu_t
bint67355042b_int
biont7727162biont
bland85320452bland
blank115418552blank
blast76532572blast
blat66550952bl_at
bleat75737002bleat
blend85317452blend
blest76431722blest
blet66247672bl_et
blin67228172blin_
blind86319322blind
blini75519272blini
blink115720142blink
blintz1788842blintz
bloat75229922bloat
blond85618372blond
blot65842322bl_ot
blub85324872blu_b
blubs95818152blubs
blue65328462blu_e
blued84520322blued
bluer74918492bluer
blues75127042blues
bluest84016482bluest
bluets87215492bluets
bluey104817052bluey
bluff134413832bluff
bluing94914482bluing
blume95619892blume
blunge94311482blunge
blunted104210662blunted
blunter94512032blunter
bluntly1235222bluntly
blur66020532blu_r
blurb95214902blurb
blurs74619082blurs
blurts84412642blurts
blush105115312blush
bound84819582bound
bounty113411072bounty
bout66353292bou_t
brant74742172brant
brent75734132brent
bruit76126722bruit
brunet84419292brunet
brung84613912brung
brunts85215452brunts
brut66537962bru_t
bun56348142b_un_
buna64730722b_una
bund75530662b_und
bundt85824852b_undt
bung75730632b_ung
bunk105731352b_unk
bunn65023652b_unn
buns66243722b_uns
bunts75729802b_unts
burnt75230322burnt
bust65947782b_ust
but55963022b_u_t
butt65143742b_utt
clung86013602clung
clunk114215082clunk
count74932052count
cunt66243672_cunt
daunt65929082daunt
dunt55746872_dunt
elint55436472elint
eluant6315092eluant
eluent6315482eluent
flaunt9712912flaunt
flint87333502flint
fluent9313932fluent
flung95114582flung
flunk125014382flunk
fluyt114614202fluyt
fount84727032fount
gaunt65430402gaunt
glint66830182glint
glut56331292glu_t
grunt65523542grunt
haunt85229132haunt
hunt76445492_hunt
jaunt125025272jaunt
lent46360532_lent
lint416266232_lint
luna46229852_luna
lune47140492_lune
lunet56835422_lunet
lung55732492_lung
lunk86030722_lunk
lunts55826902_lunts
luny77324132_luny
lust47442602_lust
mount74128062mount
plant75437112plant
plunk114514402plunk
punt65747202_punt
runt46647982_runt
shunt85226502shunt
slant55238702slant
slung65117832slung
slunk95016302slunk
slut45040592slu_t
stunt55328172stunt
taunt55532282taunt
vaunt85925312vaunt

Search took 8 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.576310227.4
2DLD Change Limit538001216.0168942.8
3Display Results1211210.296408.8
 (SQL Overall)1786911216.88825942.4
 
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.