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

242 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
anopia8341239(None) 
anopias92412481anopias
anopsia9258441anopsia
anoxia133510021anoxia
agnosia837642agnosia
alodia71112452alodia
anemia82613572anemia
anoa45634472ano__a
anodic92813132anodic
anomic102516302anomic
anomie83215962anomie
anoopsia1044362anoopsia
anopsias10337982anopsias
anosmia946642anosmia
anoxias14259112anoxias
anoxic152610672anoxic
anuria6313132anuria
aporia8315862aporia
atonia63816512atonia
atopic103514142atopic
canopic1338802canopic
myopia13318442myopia
noria55722182_noria
senopia949232senopia
sinopia947742sinopia
utopia8107882utopia
abasia8712953abasia
abelia83114413abelia
aboil72217543abo_il
abolla8410193abolla
aboma91114603abo_ma
aboulia966553aboulia
abrosia939283abrosia
abulia83512503abulia
acacia10311353acacia
acapnia1145913acapnia
acedia9310403acedia
acholia1239973acholia
acromia1139973acromia
adipic1137263adipic
adonis7314063adonis
adopt81219743adop_t
adopts998083adopts
aecia73819283a_ecia
aeolian738633aeolian
aeonian738353aeonian
aeonic83517043aeonic
aerobia939473aerobia
agapai9456863agapai
agnomina1144263agnomina
agnosias947243agnosias
agonic93515143agonic
agora6914333ago_ra
agria65517143a_gria
aioli5318313aioli_
aiolis6316843aiolis
alexia132910463alexia
allodia8128793allodia
alodial899953alodial
aloha8513623alo_ha
aloin55227423alo_in
alopecia1244433alopecia
alpha1049653a_lpha
amia66836903a__mia
ammonia1148693ammonia
amnesia938293amnesia
amnia75918643a_mnia
amoeba1035603amoeba
amusia839173amusia
ana39559833an___a
anaemia959803anaemia
analgia898363analgia
anemias92512153anemias
anemic102713693anemic
anergia847373anergia
anga56831363an__ga
angaria8311583angaria
angina7413133angina
angora71111573angora
ani37751183an__i_
anil46437433an__il
anilin6417793anilin
anima74620073an_ima
animi74016663animi_
animis84615943animis
anionic9312873anionic
anis45746473an__is
anisic8313803anisic
anna45529013an__na
annona648873annona
anoas57226493ano_as
anodal72512123anodal
anode65021043ano_de
anodes74418763anodes
anodize1738683anodize
anoint6423633anoint
anole55330383ano_le
anoles64827433anoles
anomies93316993anomies
anomy105113393ano_my
anon46134853ano__n
anonym1136383anonym
anoopsias1144253anoopsias
anorak1038923anorak
anorexia1544923anorexia
anosmias1056083anosmias
anosmic1137783anosmic
anoxemia1754773anoxemia
ansa45927773an__sa
anta46839583an__ta
anthodia1247803anthodia
anti45536363an_ti_
antiar6317173an_tiar
antic75728863an_tic
antis55033313an_tis
antra56521923an_tra
anurias7312263anurias
anuric8812113anuric
anvil82712603an_vil
aorta55922573a_orta
aphonia122711883aphonia
apian75018333a__pian
apnoea867093apno_ea
apnoeic1147613apnoeic
aporias9315163aporias
arepa75615563arep_a
aria46245433a__ria
armpit10811093armpit
aroid65428343aro_id
aroma71220153aro_ma
asocial998653asocial
aspic95114733a_spic
aspis74618143a_spis
ataxia13179593ataxia
atomic104115603atomic
atonias73315993atonias
atonic83420473atonic
atop66124753atop__
atopies92816433atopies
atopy106813393atop_y
atria56022353a_tria
atrophia1348123atrophia
atropin9311583atropin
atypic13337653atypic
avoid95516683avo_id
axonic154312723axonic
azoic162912063azo_ic
azonic175513153azonic
azotic172711633azotic
banksia1335943banksia
biopic123710673biopic
canola8313623cano_la
canonic11312933canonic
canopied1336353canopied
canopies12311853canopies
canopy1337733canop_y
chopin132712193chopin
cobia94117513_cobia
copra98115463_copra
coria75828323_coria
dopa77220903_dop_a
ectopia1147703ectopia
encomia1147983encomia
enoki9268873enoki_
enokis103010273enokis
enolic8413353enolic
enosis63816423enosis
entia5318203en_tia
entopic1149953entopic
folia83618933_folia
ganglia946613ganglia
ganoid8314443gano_id
gloria71910553gloria
gnomic11248593gnomic
gnosis75711213gnosis
gonia64117533_gonia
gopik1257533_gopik
haplopia1544783haplopia
hoopla1147633hoopla
inia45024703in__ia
knop107116603knop__
knops115911813knop_s
koppa13397293_koppa
lanolin7310643lanolin
logia68116603_logia
magnolia1144793magnolia
mahonia1238443mahonia
mania75634153man__ia
manorial10311083manorial
meropia1149623meropia
myopias14308153myopias
myopic15308463myopic
naoi46024633nao_i_
napa66927263_nap_a
nappa98511863_nappa
nappie104112263nappie
nipa69421643_nip_a
nodi56626753_nodi_
noil46133243_no_il
noir46722433_no_ir
noma67529463_no_ma
nomina83113683_nomina
nona46929063_no_na
nopal75517103_nopal
nope65934193_nop_e
nori47133143_nori_
norias65518203_norias
noris54928273_noris
nota46830773_no_ta
nova76518953_no_va
nubia7311233_nubia
obia67923113__obia
ohia75719363__ohia
panocha1444983panocha
panoply1434713panoply
panoptic1447183panoptic
phobia13278603phobia
pia56848043___pia
podia8415283_podia
poppa8409893_poppa
propria1149933propria
sandpit1049633sandpit
sangria838113sangria
scoria8513503scoria
scotia8310803scotia
senopias1048823senopias
sepia75318673_sepia
sinopias1047873sinopias
sinopie948783sinopie
synovia1345533synovia
thoria93012893thoria
topi67830393_topi_
topic95721503_topic
topis76025833_topis
tropic103014193tropic
tropin83316753tropin
uncia75015163un_cia
unopen838913unopen
unpin72613243un_pin
utopian9126273utopian
utopias9117723utopias
valonia1048303valonia

Search took 7 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.423422437.4
2DLD Change Limit1127162425.86019234.8
3Display Results2422420.0763184.2
 (SQL Overall)1786912426.35928100.5
 
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.