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

164 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
acinose93858(None) 
acerose9310892acerose
acetose938842acetose
acidoses1136772acidoses
acinous9310932acinous
acinus8311252acinus_
acnode938202ac_node
adipose1036652adipose
anginose945902anginose
arenose7311372arenose
ariose64818722ari_ose
farinose1136462farinose
lacunose1083792lacunose
laminose1036912laminose
spinose937942spinose
urinose738482urinose
abioses9311493abi_oses
acarbose1244683acarbose
acaulose1044383acaulose
accost101112263ac_cost
accuse103411033ac_cuse
acetone9310793acetone
achiness1339703achiness
achiote1239213achiote
acidness1136723acidness
acidosis1146143acidosis
acids87121003aci_ds_
aciform1446013aciform
acinar8310483acin_ar
acing87429153acin__g
acini75718983acin__i
acinic104713543acin_ic
acne66625873ac_n__e
acnes75922623ac_nes_
acnodes1037833ac_nodes
aconite9315473aconite
across8312643ac_ross
actings104512463actings_
actiniae101810013actiniae
actinide11199213actinide
actinism12119883actinism
actinoid1148013actinoid
actinon9459463actino_n
actinons10389453actinons
actins86321103actin_s_
actions94218513actions_
adenoses947903adenoses
adios65822863adi_os_
adiposes1137173adiposes
agarose838673agarose
agings86312673agings_
agios65919863agi_os_
agonise83112693agonise
ains46158883a_in_s_
albinos937653albinos_
aldose7311093a_ldose
aline57243153alin__e
alines65735223alines_
aliyos9349533aliyos_
amidase1036733amidase
amidone10349313amidone
amigos94511213amigos_
amine75835383amin__e
amines84727983amines_
amino75425503amino__
amins75534323amin_s_
amitoses1039053amitoses
amnios84912523amnios_
amniote936963amniote
amylose1237193amylose
anions64123033anions_
anise55129703a__nise
anisole71010833anisole
anode65021043a__node
anole55330383a__nole
antinode9810233antinode
antinoise949733antinoise
antinome10810443antinome
appose10411993a_ppose
arabinose1144063arabinose
arginase946433arginase
ariosi64313033ari_osi
arioso64312403ari_oso
arise56436433ari__se
arkose104911343a_rkose
arose55832083a__rose
asinine7310723asinine
atingle848253atingle
avions94114393avions_
avisos95410483avisos_
axions134713483axions_
ayins85321613ayin_s_
azine146721413azin__e
azines155517073azines_
caboose1138273caboose
cains75334303cain_s_
calcinoses1445123calcinoses
callose9313663callose
canoe75627253_cano_e
canoes84725883_canoes
caseose939163caseose
casinos93512833casinos_
cenote83715843_cenote
cense75121403_cen_se
chinone12510153chinone
chinos115018693chinos_
choose115116143_choose
chose105925403_c_hose
cine66242943_cin__e
cineole91010003_cineole
cines75239683_cines_
cinque1736853_cinque
cions75222853_cions_
cirrose937473_cirrose
citole8311503_citole
close76425223_c_lose
comose105016843_comose
cymose13429653_cymose
dinos65428063_dinos_
facings134511263facings_
filose96112503_filose
finos86226953_finos_
hardnose1245723hardnose
hawknose1842323hawknose
hognose11117243hognose
iciness938863iciness
icings9428453icings_
jacinthe2052503jacinthe
kinase104210653_kinase
kinos96626143_kinos_
laciness102112553laciness
lacings105013653lacings_
lactose969473lac_tose
ladinos8389963ladinos_
lanose6313593_lanose
latinos73613803latinos_
linos55631503_linos_
macintosh1641703macintosh
mannose939243mannose
nose46739363___nose
otiose639403oti_ose
palinode1145713palinode
pilose84514243_pilose
pinole83218783_pinole
pruinose1044853pruinose
quinone16217463quinone
racemose1245003racemose
raciness102413453raciness
racings105015133racings_
raffinose1542193raffinose
rhinos94411123rhinos_
ribose839893_ribose
rimose8310593_rimose
rinse54820973_rin_se
scapose1147753scapose
scions82612243scions_
tacnode1045093tac_node
triose64715383tri_ose
vaginoses1344143vaginoses
varicose1346703varicose
venose9310843_venose
vinos84723073_vinos_
winoes94317013_winoes
winos84625043_winos_

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271645.90622693.4
3Display Results1641640.0463565.2
 (SQL Overall)1786911646.34228175.8
 
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.