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 “blears” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
blears8511645(None) 
bears75739041b_ears
bleaks125112431bleaks
blear75918681blear_
bleary115112551bleary
bleats85518611bleats
clears84116561clears
lears55938731_lears
alegars838932alegars
altars64518152altars
anears63717182anears
balers85626932bale_rs
bars66564092b__ars
bazars174613112bazars
beads85429502b_eads
beaks115326622b_eaks
beams95328172b_eams
beans75734692b_eans
bear66844642b_ear_
beard86024962b_eard
beards94116672b_eards
beats76042242b_eats
beaus75127112b_eaus
beers75628392b_eers
belays114313852belays
beleaps1138052beleaps
biers76225222bie_rs
blabs95619632bl_abs
blahs105616512bl_ahs
blams95023852bl_ams
blare75826232bl_are
blares85021632bl_ares
blats75132502bl_ats
blaws105620462bl_aws
bleach133611402bleach
bleak115915382blea_k
bleared104211252bleared
bleat75737002blea_t
bleaters103412322bleaters
blebs96416152ble_bs
bleeds95211592bleeds
bleeps10499102bleeps
blends96012882blends
bless75917812ble_ss
blets75324942ble_ts
bloats85215762bloats
blurs74619082bl_urs
boars75229602b_oars
boyars115611982boyars
breads95419202breads
breaks124816422breaks
breams104815042breams
briars84814822briars
cleans85817052cleans
clear76219052clear_
cleats84919312cleats
dears65736882_dears
drears74614252drears
ears46356592__ears
fears84829392_fears
fleams115011942fleams
fleas86423662flea_s
fleers96015792fleers
gears64628692_gears
gleams94812252gleams
gleans75014742gleans
hears86737372_hears
lars46956572_l_ars
leads66028492_leads
leafs85721182_leafs
leaks95923912_leaks
leans55536252_leans
leaps75522932_leaps
lear47045952_lear_
learn55322662_learn
learns65513742_learns
leary85927382_leary
leas45954182_lea_s
leers54828982_leers
lehrs86111132_lehrs
liars54723162_liars
nears55529422_nears
pears75138612_pears
pleads94613952pleads
pleas75627032plea_s
pleats85218592pleats
rears54739652_rears
sears54744912_sears
shears93820902shears
smears84714432smears
spears84019472spears
swears94114072swears
tears55436462_tears
velars93913722velars
wears86030302_wears
years84527672_years

Search took 4 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 Filter178691825510.376475242.0
2DLD Change Limit82551962.61031628.7
3Display Results96960.0303200.0
 (SQL Overall)178691963.01659247.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.