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

122 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
areae5522974(None) 
area45843391area_
areal55928731areal
areas55935771areas
arene55329411arene
arete56031351arete
abeam9316532abeam
abele76323252abele
acreage1037842acreage
aerate64830552aerate
aerie54634602aerie
agee56241492age_e
agene65621582agene
agree65226032agre_e
ahead96817052ahead
ajee115928232aje_e
akee85936812ake_e
akene95818662akene
alae45643752a_lae
alee46652322ale_e
algae65319622algae
amebae1049632amebae
anear55420322anear
anele55628832anele
ansae55720972ansae
antae56828292antae
aortae65115472aortae
apeak115513452apeak
aquae142212712aquae
arak86929572ar_ak
arame75026622arame
arcade91013642arcade
arcane81216742arcane
are37874572ar__e
areca75618632areca
arecas84817442arecas
areic73219392areic
arena55323812arena
arenas65021992arenas
arenes64928392arenes
areolae7811732areolae
areole61017282areole
arepa75615562arepa
arepas85515702arepas
ares45871022are_s
aretes64425352aretes
argal65023392argal
argle65421562argle
argue64818442argue
arhat8327092arhat
aria46245422aria_
arias55438022arias
arise56436432arise
arose55832082arose
arras55626132arras
array86317142array
arrear6310252arrear
arse46539272ar_se
artal55525472artal
arval86017012arval
asea46327182asea_
aurae54128112aurae
aureate72515282aureate
awee76336642awe_e
barege94713542barege
brae65639112br_ae
bread85523112bread
break115319402break
bream95121812bream
brede85520502brede
bree67241262bre_e
breve105317052breve
creak115418432creak
cream95721352cream
crease85519572crease
create85126382create
creme94319322creme
crepe95520722crepe
dread74419022dread
dream85120392dream
drear65016902drear
dree56638322dre_e
frae75330472fr_ae
freak125115242freak
free75940182fre_e
frere85617722frere
galeae74717452galeae
grease75416232grease
great66034242great
greave104611492greave
grebe85114942grebe
gree56641562gre_e
krewe1238192krewe
laree56036292lare_e
larvae938842larvae
ocreae83310272ocreae
oread64619602oread
paleae84820292paleae
parae76335702par_ae
pareve114613012pareve
pree67044732pre_e
prese75228382prese
read55942532_read
real45750292_real
ream65841612_ream
reap65934742_reap
rear45644552_rear
reave84528022_reave
rede55037672_rede
ree37974072_re_e
rete44944132_rete
saree55044662sare_e
tread64821702tread
treat56240352treat
tree47745812tre_e
urea46528062urea_
ureal56722682ureal
ureas55826012ureas
urease64516992urease
ursae55214452ursae
wreak125513272wreak
zoeae144412482zoeae

Search took 3 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.330541487.9
2DLD Change Limit538001221.67032215.6
3Display Results1221220.0304066.7
 (SQL Overall)1786911222.03088025.1
 
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.