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

137 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
areal5592873(None) 
area45843391area_
areae55229741areae
areas55935771areas
argal65023391argal
artal55525471artal
arval86017011arval
real45750291_real
ureal56722681ureal
aal39058672a__al
abeam9316532abeam
acetal84314902acetal
adrenal838262adrenal
aerial64625712aerial
ahead96817052ahead
akela9311342akela
algal66518222algal
anal48037522a_nal
anear55420322anear
annal56520762annal
anneal64812292anneal
aortal65217512aortal
apeak115513452apeak
apneal83411122apneal
appal95315222appal
appeal103911612appeal
arak86929572ar_ak
are37874572are__
areally10411242areally
areca75618632areca
arecas84817442arecas
areic73219392areic
arena55323812arena
arenas65021992arenas
arene55329412arene
areola6813672areola
areole61017282areole
arepa75615562arepa
arepas85515702arepas
ares45871022are_s
arete56031352arete
argala74712672argala
argali75013752argali
argals75517712argals
argil65116882argil
argol65317262argol
arhat8327092arhat
aria46245422aria_
arias55438022arias
ariel55228972ariel
aril45843022ar_il
arras55626132arras
array86317142array
arrear6310252arrear
arsenal739382arsenal
artel56122742artel
aryl75922342ar_yl
asea46327182asea_
atrial65418942atrial
aural54428962aural
axal116520492a_xal
axel115222072axe_l
axial124515192axial
barbal104016662barbal
boreal84817212boreal
bread85523112bread
break115319402break
bream95121812bream
carnal83919202carnal
carpal103716252carpal
cereal8315832cereal
craal74117752craal
creak115418432creak
cream95721352cream
credal9311672credal
creel75121482creel
deal56347412_deal
dread74419022dread
dream85120392dream
drear65016902drear
farfal123410182farfal
feal713940422_feal
feral85424652feral
freak125115242freak
graal64316502graal
great66034242great
hartal9415472hartal
heal75645692_heal
ideal65716392ideal
ileal56118082ileal
irreal657832irreal
kraal94511822kraal
larval948502larval
leal46043272_leal
loreal63814312loreal
meal65643172_meal
narial6317952narial
narwal938942narwal
oral47638122or_al
ordeal779252ordeal
oread64619602oread
paleal84716672paleal
parral85517532parral
peal68648102_peal
ramal74622242ramal
ratal55025112ratal
read55942532_read
realm75621622_realm
reals55038652_reals
ream65841612_ream
reap65934742_reap
rear45644552_rear
reel45240532_reel
regal65023792_regal
renal55929502_renal
rial45938092_rial
seal45654372_seal
seral56336382seral
sheal84927702sheal
steal56125472steal
tarnal63716502tarnal
tarsal63315272tarsal
teal45546502_teal
tread64821702tread
treat56240352treat
trial54926352trial
unreal64414452unreal
urea46528062urea_
ureas55826012ureas
urial54823022urial
uveal84411072uveal
veal76936812_veal
weal75838682_weal
wheal115716182wheal
wreak125513272wreak
zeal135530332_zeal
zoeal144813782zoeal

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.313570897.8
2DLD Change Limit538001371.64332745.0
3Display Results1371370.0433186.0
 (SQL Overall)1786911371.99989390.2
 
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.