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

183 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
amosite931316(None) 
amosites10311231amosites
aconite9315472aconite
ammonite1249142ammonite
amusive1246252amusive
apposite12410012apposite
campsite1447412campsite
inosite7314062inosite
jarosite1548382jarosite
moste75925082_mos_te
ramosity1345892ramosity
abusive1245283abusive
acolyte12157653acolyte
aconites10314353aconites
adamsite1144423adamsite
aerolite8315053aerolite
agonise83112693agonise
agonize172911403agonize
albite8313313a_lbite
almost81014433almos_t_
alsike1047913a_lsike
alunite7311633alunite
amanita9310453amanita
amative12311733amative
amazonite2044213amazonite
ambit94223713am_bit_
ambits103713413am_bits
ambsace1355963ambsace
amenity1238333amenity
amesace1147733amesace
amice96122873am__ice
amide86128483am__ide
amidine103613853amidine
amie66339853am__i_e
amine75835383am__ine
aminity12310513aminity
amirate91115953amirate
amity10416093am__ity
ammine10314493am_mine
ammocete1444443ammocete
ammoniate1345483ammoniate
ammonites1348143ammonites
amniote936963amniote
amoebae1145533amoebae
amole75724593amo__le
amorini9310353amorini
amorino9310253amorino
amorist9317643amorist
amorists10411333amorists
amort75832203amo_rt_
amortise10428513amortise
amortize1987743amortize
amotion9710473amotion
amount8414483amount_
amounted1135533amounted
amounts937043amounts
amrita8411133am_rita
amuse75920833amus__e
amusia839173amusi_a
amusias938583amusias
amusing1039383amusing
andesite949453andesite
animosity1445253animosity
anodize1738683anodize
anolyte10159003anolyte
anomie83215963anomi_e
ansate64517863a_nsate
apatite9312963apatite
aplite8316393a_plite
apostate1049853apostate
apostil947903apostil
apostle937853apostle
arcsine94512393arcsine
arenite71017713arenite
armoire938133armo_ire
arose55832083aros__e
arsine64021043a_rsine
artiste73813693artiste
aside65122083a__side
assize1538633a_ssize
atomise93013823atomise
atomize183111823atomize
attrite7311833attrite
augite7312613a_ugite
avodire1143763avodire
avoset9315673avoset_
avosets1036663avosets
axite125218253a__xite
azote144416343azo__te
azotise1637073azotise
azotize1537083azotize
azurite1638003azurite
biotite9311033biotite
boite74426323_bo_ite
camomile14156323camomile
campsites1546473campsites
coesite9713623coesite
composite15410153composite
cosie74728263_cosi_e
cosine83823513_cosine
diorite8314913diorite
dumpsite1344293dumpsite
ebonite9310293ebonite
emote75421193emo__te
emotive1239193emotive
eosine64519413_eosine
erosive1039193erosive
favorite1447313favorite
felsite1039083felsite
fomite113314073_fomite
hessite1038993hessite
homesite1359263homesite
impolite1249293impolite
inosine7314283inosine
inosites8312793inosites
iolite63221983_iolite
jarosites1647373jarosites
kamacite1645293kamacite
laborite10410693laborite
lanosity1146353lanosity
limonite1048163limonite
mannite9312903mannite
marlite92917073marlite
marmite112413993marmite
masonite1049683masonite
massive12289773massive
misate81222693_misate
miscite11314383_miscite
mite66249413_m__ite
mobile103613543_mobile
modiste1039283_modiste
moire71017323_mo_ire
moist76033583_moist_
moisten93110143_moisten
moister94015373_moister
moline84422033_moline
monie75631653_moni_e
monte75829773_mo_nte
mosque17287163_mosque
most66554203_mos_t_
mosts76028543_mos_ts
mote67048083_mo__te
motile83818343_motile
motive113112143_motive
motte75526973_mo_tte
movie105319133_movi_e
moxie144018123_moxi_e
myosote1245853myosote
niobite937953niobite
norite63221133_norite
oolite63319603_oolite
opposite1247133opposite
parasite10314843parasite
piosity1268643piosity
plosive1236673plosive
podite93315353_podite
polite83625073_polite
posit75833333_posit_
posited10511493_posited
posits85718713_posits
postie84123963_postie
prosit85124593prosit_
prostie91617743prostie
ramose8314403ramos__e
ramosities1246863ramosities
resite64128453_resite
rimosity1345713rimosity
samite83020603sam__ite
saponite10410533saponite
site47052413___site
smite75224873sm__ite
smote75820283smo__te
somite84519373_somite
sopite84917713_sopite
subsite9412873subsite
taconite1049313taconite
teosinte845543teosinte
thorite10313443thorite
vamose1159283vamos__e
vamosing1435593vamosing
website1235323website
zeolite1638903zeolite
zoisite1635833zoisite

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.410435831.7
2DLD Change Limit1340271836.59320328.7
3Display Results1831830.0603050.0
 (SQL Overall)1786911837.06325299.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.