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

144 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
amorini931035(None) 
amorino9310251amorino
adoring9412522adoring
amorist9317642amorist
armoring1149122armoring
aboding11410123aboding
aborning1188003aborning
aborting11710253aborting
acarine9316003acarine
acini75718983a__cini
acorn75616623acor_n_
acorns85013013acor_ns
admiring1236133admiring
adorn64917093ador_n_
adorning1087323adorning
adorns74212613ador_ns
airing74927503a_iring
aldrin7311243aldrin_
aldrins8310203aldrins
aloin55227423alo_in_
aloins65022203alo_ins
amain74922913am_ain_
amarna839793amar_na
amarone9311203amarone
amazing1938813amazing
amberina1247393amberina
ambling121411793ambling
amboina1137963amboina
ambries111614553ambries
amercing1337193amercing
amici94217393am__ici
amidin94015673amidin_
amidine103613853amidine
amidins103713103amidins
amin66042253am__in_
amine75835383am__ine
aminic104413513am__inic
amino75425503am__ino
amins75534323am__ins
ammine10314493am_mine
ammino1069883am_mino
among85813303amo__ng
amoral8314633amor_al
amoretti1095523amoretti
amoristic1347993amoristic
amorists10411333amorists
amoroso946093amoroso
amorous9311133amorous
amort75832203amor__t
amortise10428513amortise
amortize1987743amortize
amosite9313163amosite
amotion9710473amotion
amotions1069843amotions
amount8414483amo_unt
amping114317573am_ping
amrita8411133am_rita
amusing1039383amusing
anoint6423633ano_int
aorist64827873a_orist
apocrine1246933apocrine
aporia8315863apori_a
aporias9315153aporias
armorial1049453armorial
armories10313653armories
armouring1244983armouring
aroint6328153aro_int
atoning83514873atoning
avowing1466603avowing
bambini1336583bam_bini
boring94724873_boring
chorine123218363chorine
choring133617663choring
clamoring1477423clamoring
coring94433963_coring
emeriti949433emeriti
emodin9310353emodin_
emodins1039433emodins
emoting10313563emoting
enamoring1247033enamoring
favoring1596673favoring
florin9312653florin_
florins10311643florins
forint9325023_forint
goring84119573_goring
humoring1456853humoring
imprint11312563imprint
laboring112110143laboring
majoring1836363majoring
marina84623413_marina
marine84230403_marine
marring103319553marring
martini93613873martini
merino8315093_merino
mini65634563_m__ini
mirin75023153_mirin_
miring93723803_miring
mirins83918903_mirins
moirai886913_moirai
moline84422033_moline
mooing93718373_mooing
mooring102514443mooring
moping114017103_moping
moraine9314573_moraine
morainic12125673_morainic
morion86217733_morion
morions94014643_morions
morn66237563_mor_n_
morning103215043_morning
morns75527443_mor_ns
moron76925423_moron_
moronic11311863_moronic
morons84919543_morons
moving123913283_moving
mowing124119093_mowing
murine84220023_murine
muring95120373_muring
oribi7311093__oribi
pecorini1246553pecorini
porcini1137633_porcini
poring94227273_poring
razoring1836443razoring
rumoring1136983rumoring
savoring1269483savoring
scoring103117213scoring
shoring112820073shoring
smoking143210523smoking
snoring83917203snoring
sordini8228963_sordini
soring74731883_soring
sporing104319413sporing
storing83921123storing
taborin92210453taborin_
taborine102510683taborine
taboring113010193taboring
taborins103310223taborins
tamarin9311913tamarin_
tamarind1147023tamarind
tamarins10310843tamarins
torii55521593_tori_i
vamosing1435593vamosing
vaporing1437653vaporing
whoring142910293whoring
yogini10449143_yogini

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.1401276364.3
2DLD Change Limit1340271447.20618599.4
3Display Results1441440.0602400.0
 (SQL Overall)1786911447.40624127.9
 
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.