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

106 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
drear6501690(None) 
dear55343601d_ear
dread74419021dread
dream85120391dream
drears74614251drears
dreary104611671dreary
rear45644551_rear
anear55420322anear
area45843402area_
areae55229752areae
areal55928742areal
areas55935792areas
arrear6310252arrear
bear66844642_bear
blear75918682blear
bread85523112bread
break115319402break
bream95121812bream
briar75718152briar
clear76219052clear
creak115418432creak
cream95721352cream
damar84117752damar
darbar959962darbar
darer65230792dare_r
dead65434242d_ead
deaf85838402d_eaf
deair65817192d_eair
deal56347412d_eal
dean56039482d_ean
dears65736882d_ears
deary95826842d_eary
debar85517862debar
deer56739022d_eer
denar65223292denar
derat65044082derat
deray95024182deray
dewar95817732dewar
dinar66319892dinar
direr64927072dire_r
doer57734702doe_r
dogear838192dogear
drab76226452dr_ab
drag64825052dr_ag
dram75832002dr_am
drat56247832dr_at
draw85623012dr_aw
dray85428092dr_ay
dreads84115022dreads
dreamer104110842dreamer
dreams94513982dreams
dreamt94615712dreamt
dreamy12509992dreamy
dreck124812802dreck
dree56638322dre_e
dreed75222842dreed
drees65628522drees
dreg66821652dre_g
dregs76114862dregs
drek96321092dre_k
dreks105714752dreks
dress65319832dress
drest65530342drest
drew86221672dre_w
drier64423962drier
dryad10477582dryad
dryer95111462dryer
durbar968722durbar
dyer85522112dye_r
ear36867882__ear
fear75337792_fear
freak125115242freak
freer86021242freer
friar85414272friar
gear55934972_gear
great66034242great
hear76143882_hear
lear47045952_lear
near45236502_near
oread64619602oread
pear69745232_pear
prearm104512352prearm
prewar114712582prewar
read55942532_read
real45750292_real
ream65841612_ream
reap65934742_reap
rearm75923572_rearm
rears54739652_rears
rebar75420192_rebar
roar46328572_roar
sear47353842_sear
shear85424832shear
smear74416392smear
spear75821062spear
swear85316852swear
tear45242882_tear
tread64821702tread
treat56240352treat
uprear8168792uprear
urea46528062urea_
ureal56722682ureal
ureas55826012ureas
wear75836722_wear
wreak125513272wreak
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.313570897.8
2DLD Change Limit538001061.57634137.1
3Display Results1061060.0303533.3
 (SQL Overall)1786911061.91993116.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.