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

193 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
anopias9241248(None) 
anopia83412391anopia_
anopsias10337981anopsias
anoxias14259111anoxias
agnosias947242agnosias
anemias92512142anemias
anoas57226492ano__as
anomies93316992anomies
anoopsias1144252anoopsias
anopsia9258442anopsia_
anosmias1056082anosmias
anoxia133510022anoxia_
anurias7312252anurias
aporias9315152aporias
atonias73315992atonias
atopies92816432atopies
canopies12311852canopies
myopias14308152myopias
norias65518202_norias
senopias1048822senopias
sinopias1047872sinopias
utopias9117722utopias
abasias9711013abasias
abelias93213563abelias
abomas101113583abo_mas
aboulias1065543aboulias
abrosias1049033abrosias
abulias93210693abulias
acacias11510403acacias
acapnias1255683acapnias
acedias1039773acedias
acholias1349573acholias
adonis7314063adoni_s
adopts998083adop_ts
aeolian738623aeolian
aeonian738353aeonian
agnosia837643agnosia_
agonies83016623agonies
agoras7613343ago_ras
agrias74315393a_grias
aiolis6316843aioli_s
alexias14249793alexias
alias55834603a__lias
alodia71112453alodia_
alodial899953alodial
alohas9411703alo_has
aloins65022203alo_ins
alopecias1344413alopecias
alphas1139513a_lphas
amias75831473a__mias
ammonias1247953ammonias
amnesias1047833amnesias
amoebas1135963amoebas
amusias938583amusias
anabas8314083an_abas
anaemias1069203anaemias
analgias9107803analgias
anaphase1345463anaphase
anas46649863an___as
anemia82613573anemia_
anergias947173anergias
angarias9310553angarias
angas65827983an__gas
anginas8310953anginas
angoras8811363angoras
anilins7416793anilins
anils56326723an__ils
animas84418723an_imas
animis84615943animi_s
anis45746463an__i_s
anlas55626933an__las
annas55824883an__nas
annonas738793annonas
anoa45634473ano__a_
anodal72512123ano_dal
anodes74418763ano_des
anodic92813133anodi_c
anodize1738683anodize
anodizes1837963anodizes
anoint6423633ano_int
anoints7311063anoints
anoles64827433ano_les
anomic102516303anomi_c
anomie83215963anomi_e
anonyms1235443anonyms
anoopsia1044363anoopsia_
anorak1038923ano_rak
anoraks1137603anoraks
anorexias1644403anorexias
anosmia946643anosmia_
anoxemias1844543anoxemias
anoxic152610673anoxi_c
antas55432033an__tas
antiar6317173an_tiar
antiars7314623an_tiars
antibias10312083antibias
antics84621453an_tics
antis55033313an_ti_s
anuria6313123anuria_
anvils9219713an_vils
aortas65417783a_ortas
aphonias132611143aphonias
apian75018333a__pian
apnoeas946353apno_eas
aporia8315863aporia_
arepas85515703arep_as
arias55438023a__rias
armpits1157133armpits
aroids75118223aro_ids
aromas81018613aro_mas
asocial998653asocial
asocials1075683asocials
aspics104211563a_spics
aspis74618143a_spi_s
ataxias14189343ataxias
atomics113110853atomics
atomies93918363atomies
atonia63816513atonia_
atonics93613713atonics
atonies75320953atonies
atopic103514143atopi_c
atrophias1447933atrophias
atropins10410493atropins
avoids104410203avo_ids
axoplasm1943733axoplasm
banksias1445893banksias
biopics13318543biopics
canolas9313993cano_las
canopic1338803canopi_c
canopied1336343canopied
capias10318353_capias
chopins142312243chopins
cobias104014993_cobias
copies104130303_copies
copras103517153_copras
dopas85019063_dop_as
ectopias1248273ectopias
enokis103010273enoki_s
enosis63816423enosi_s
ganoids939333gano_ids
glorias81610323glorias
gnosis75711213gnosi_s
haplopias1644713haplopias
hooplas1239203hooplas
jalopies1786673jalopies
knops115911813knop__s
koppas14407603_koppas
lanolins8310533lanolins
magnolias1244723magnolias
mahonias1348063mahonias
manias84029033man__ias
manorial10311083manorial
meropias1249963meropias
myopia13318443myopia_
myopies14309723myopies
napas75924353_nap_as
nappas105511613_nappas
nappies114613393nappies
nipas77116673_nip_as
noils55024333_no_ils
noirs55615463_no_irs
nomas74726413_no_mas
nonas55126653_no_nas
nopal75517103_nop_al
nopals84914023_nopals
noria55722183_noria_
noris54928273_nori_s
novas85215363_no_vas
nubias8310093_nubias
obias76116863__obias
ohias84415573__ohias
panochas1545653panochas
panoplies1346003panoplies
phobias14228183phobias
pias66542553___pias
poppas93710713_poppas
sandpits1146843sandpits
sangrias938373sangrias
scotias939753scotias
senopia949233senopia_
sepias83616103_sepias
sinopia947743sinopia_
synovias1445303synovias
thorias102312053thorias
topics104714583_topics
topis76025833_topi_s
tropics113610653tropics
tropins93116313tropins
unpins82312383un_pins
utopia8107883utopia_
utopian9126273utopian
utopians1094903utopians
valonias1147473valonias

Search took 8 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 Filter1786911340270.750238254.7
2DLD Change Limit1340271936.89019452.4
3Display Results1931930.0633063.5
 (SQL Overall)1786911937.70323197.6
 
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.