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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

263 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
atrium841183(None) 
atriums939061atriums
natrium948991natrium
aecium10410422aecium
allium8311252allium
antrum8611312antr_um
apterium1249152apterium
arum66129032a_r_um
atria56022352atri_a
atrial65418942atrial
atrip75315752atri_p
aurum7614962aur_um
barium10313522barium
cerium10313772cerium
corium10315722corium
curium10312502curium
natriums1046312natriums
strum75619452str_um
trim65329522_tri_m
yttrium1244102yttrium
abri65522213abri__
abris75722603abri_s
acetum1038463acetum
acrid86920103acri_d
actinium1297563actinium
adrift10313113adrift
adytum1243733adytum
aerial64625713aerial
aerie54634603aeri_e
aeried74221873aeried
aerier64823163aerier
aeries64737783aeries
aerify122810113aerify
aerily93017013aerily
aerobium1246303aerobium
affirm1435523affirm
afrit8323173afri_t
afrits9311903afrits
ageism968803ageism
agism84614063a_gism
agria65517143agri_a
agrias74315393agrias
aim57858223a__i_m
airbus848343airbus
airier64619363airier
airily93014823airily
airing74927503airing
alarum85411983alarum
album92312653a_lbum
algum82711763a_lgum
alliums957973alliums
alodium1047583alodium
altruism1055373altruism
alum65227613a__lum
amrita8411133amrita
amylum1344693amylum
anthurium1444373anthurium
antrums969173antr_ums
aorist64827873aorist
aquarium1945383aquarium
arcus76918863a_rcus
argue64818443a_rgue
argus66716543a_rgus
aria46245423a_ri_a
arias55438023a_rias
arid57642723a_ri_d
ariel55228973a_riel
aril45843023a_ri_l
arils58732203a_rils
arise56436433a_rise
arm58449623a_r__m
arriba867683arriba
arris56824683arri_s
arrive91311793arrive
artful968273artful
artier63419733artier
artily92814713artily
artist64125543artist
arums75517833a_r_ums
asarum84610913asarum
asterism10413273asterism
astrict9614793astrict
astride8311973astride
asylum1144893asylum
atavism1238033atavism
atheism1248523atheism
atilt54828473at_ilt
atom67824523at__om
atomism112610963atomism
atropism1247993atropism
attic75618353atti_c
attics84413283attics
attire62412383attire
attrit6315753attri_t
attrite7311833attrite
attrits7310623attrits
aureus65314883aureus
auric74521743auri_c
auris55331533auri_s
aurist65027253aurist
aurous64119263aurous
aurums849383aur_ums
autism83815333autism
axiom143913593a_xiom
bacterium1546683bacterium
bariums1139153bariums
bohrium1475013bohrium
bothrium1585023bothrium
brim85629373_bri_m
cadmium1446113cadmium
caesium1158833caesium
calcium1368593calcium
cambium1537323cambium
ceriums1139483ceriums
cesium1039583cesium
chrism13710673chrism
cilium104311373cilium
conium10415313conium
crinum1039333_crinum
curiums1138503curiums
datum8310633dat__um
dirdum1036033dirdum
dorsum947623dorsum
drum76521593_dr_um
durum8513203dur_um
elaterium1146363elaterium
erbium1038083erbium
estrum81810513estr_um
fermium1446353fermium
ferrum1147453ferrum
folium11310453folium
forum108318763for_um
gallium1037953gallium
gonium949803gonium
grim76929423_gri_m
grum75625083_gr_um
hafnium1544243hafnium
hahnium1544433hahnium
hassium1236133hassium
helium112311253helium
iatric8312173iatri_c
ilium74614183_ilium
indium939503indium
ionium8610923ionium
iterum837903iterum
jorum145513743jor_um
kalium1239473kalium
labium10410243labium
labrum1057423labr_um
larum74317973lar_um
latria62313613latri_a
latrias71913213latrias
latrine7715133latrine
lithium1245823lithium
lyrism1137473lyrism
masurium1245893masurium
matrix1539853matri_x
medium113711623medium
milium104712683milium
minium106014423minium
naturism1047893naturism
odium83413033_odium
ogrism937913ogrism
oidium959813oidium
onium73115533_onium
opium92812093_opium
osmium1036573osmium
ostium8310133ostium
pallium1149023pallium
pastorium1347713pastorium
patagium1375433patagium
patriot9314543patriot
podium112911913podium
porism104518063porism
prim85132203_pri_m
prism94820263_prism
purism104715063purism
radium93513293radium
retrim83514883retri_m
rim56052283__ri_m
rum56644643__r_um
sacrum103910143sacr_um
samarium1257283samarium
scrim95419743scri_m
scrum95418203scr_um
serum75223473ser_um
sodium92111453sodium
stadium1038073stadium
sternum947733sternum
stibium1145843stibium
stratum9318253stratum
stream84717293stream
stria55723213stri_a
striae65422273striae
striatum1044473striatum
strick124813203strick
strict84821043strict
stride75420963stride
strife95318363strife
strike105619733strike
string75327563string
strip77524343stri_p
stripe85822443stripe
strips85719653strips
stript85222193stript
stripy115812743stripy
strive95020963strive
stroud7310383stroud
struma84313273str_uma
strums84716453str_ums
strut56030733str_ut
stum65526023st__um
talcum1036953talcum
tantrism1048373tantrism
tantrum946683tantr_um
tariff12711363tariff
taring73932283taring
tarsus6310513tarsus
tedium9269873tedium
telium82611403telium
terbium1147293terbium
tergum937933tergum
thorium12208413thorium
thrum104713633_thrum
tram67034553_tr_am
trauma838803_trauma
triac74116373_triac
triad65217723_triad
trial54926353_trial
tribe74420273_tribe
trice75127493_trice
trick115420693_trick
triduum1043413_triduum
tried65026913_tried
trier54328533_trier
tries55742813_tries
trig55528163_tri_g
trigo65716053_trigo
trigs65423063_trigs
trike95320163_trike
trill55122933_trill
trims75021473_trims
trine54734603_trine
trio45233343_tri_o
triol55521363_triol
trios55528093_trios
trip66830393_tri_p
tripe75425383_tripe
trips74923363_trips
trite54730033_trite
tritium969013_tritium
triumph1453343_triumph
triune64210183_triune
trivium1256143_trivium
trout57332573_trout
true46725853_tr_ue
trug55720043_tr_ug
truism8118623_truism
trump95615123_tr_ump
untrim8310683untri_m
verism113214263verism
yttriums1343233yttriums
zoarium1846093zoarium

Search took 9 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 Filter1786911127160.796224486.2
2DLD Change Limit1127162637.76314519.6
3Display Results2632630.2501052.0
 (SQL Overall)1786912638.80920285.0
 
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.