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

115 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
blear7591868(None) 
bear66844641b_ear
bleak115915381bleak
blears85116451blears
bleary115112551bleary
bleat75737001bleat
clear76219051clear
lear47045951_lear
abler75624312able_r
alar46340072al_ar
alegar739282alegar
altar55520642altar
anear55420322anear
baler75635272bale_r
bar58070552b__ar
bazar163816002bazar
bead75937922b_ead
beak106534382b_eak
beam86939232b_eam
bean66443862b_ean
beard86024962b_eard
bears75739042b_ears
beat66168302b_eat
beau66137272b_eau
beer65635992b_eer
belay105021522belay
beleap10410282beleap
bier65531832bie_r
blab86629132bl_ab
blae66134642bl_ae
blah98625062bl_ah
blam86131702bl_am
blare75826232bl_are
blat66550952bl_at
blaw97026722bl_aw
bleach133611402bleach
bleaker133510532bleaker
bleaks125112432bleaks
bleared104211252bleared
bleater94515302bleater
bleats85518612bleats
bleb85425222ble_b
blebs96416152blebs
bled75729312ble_d
bleed85019802bleed
bleep95013452bleep
blend85317452blend
blent76230952blent
bless75917812bless
blest76431722blest
blet66247672ble_t
blets75324942blets
blew94722432ble_w
bloat75229922bloat
bluer74918492bluer
blur66020532bl_ur
boar66134292b_oar
bolar75123472bolar
boyar106013762boyar
bread85523112bread
break115319402break
bream95121812bream
briar75718152briar
bulbar1039582bulbar
clean75420412clean
clears84116562clears
cleat76335062cleat
dear55343602_dear
drear65016902drear
ear36867882__ear
fear75337792_fear
flea75628492flea_
fleam106017282fleam
fleas86423662fleas
fleer86020772fleer
gear55934972_gear
gleam86916732gleam
glean65818202glean
hear76143882_hear
ilea45931462ilea_
ileac75814172ileac
ileal56118082ileal
lar37967532_l_ar
lea37660182_lea_
lead56038852_lead
leaf76441032_leaf
leak86233712_leak
leal46043272_leal
lean46345242_lean
leap66032682_leap
learn55322662_learn
lears55938732_lears
leary85927382_leary
leas45954182_leas
leer46239352_leer
lehr75514942_lehr
liar47229682_liar
near45236502_near
olea46532722olea_
pear69745232_pear
plea66830602plea_
plead85818462plead
pleas75627032pleas
pleat74734472pleat
rear45644552_rear
sear47353842_sear
shear85424832shear
smear74416392smear
spear75821062spear
swear85316852swear
tear45242882_tear
ulnar56013982ulnar
velar85817632velar
wear75836722_wear
year76534252_year

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 Limit538001151.42037887.3
3Display Results1151150.0333484.8
 (SQL Overall)1786911151.749102167.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.