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 “amoroso” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
amoroso94609(None) 
amorino9310252amorino
amorist9317642amorist
amorous9311132amorous
morose85116242_morose
oloroso744612oloroso
aborts84916183aborts_
acerose9310893acerose
acorns85013013acorns_
across8312643a_cross
adobos9438453adobos_
adores74420713adores_
adorns74212613adorns_
aerosol747683a_erosol
agarose838653agarose
aggros836543aggros_
agoras7613343agoras_
agorot7414993agoro_t
agoroth1145133agoroth
ahorse9311513ahor_se
amarone9311193amarone
ambos95321243am_bos_
ambroid1238863ambroid
ambrosia1245533ambrosia
amigos94511203amigos_
amirs75924913amir_s_
ammono1047373am_mono
ammos94815823am_mos_
amnios84912513amnios_
amoks11413553amo_ks_
amoles84122193amoles_
amongst1045363amongst
amoral8314623amor_al
amoretto1095793amoretto
amorini9310353amorini
amorists10411323amorists
amorously1446593amorously
amort75832203amor__t
amortise10428513amortise
amours83512643amours_
amylose1237183amylose
andros7313303andros_
aorist64827873a_orist
arioso64312403a_rioso
armors85017813armor_s_
arose55832083a__rose
arroyo936963a_rroyo
doloroso943173doloroso
macros104017013macros_
madrono10288743madrono
mafioso1244453mafioso
mojos145314463_mojos_
monos75930863_monos_
moors74923143_moors_
moos66051303_mo_os_
moose76327193_mo_ose
moras76438763_moras_
morass84614493_morass
mores76249643_mores_
morns75527443_morns_
morocco1343523_morocco
moron76925423_moro_n
morons84919543_morons
morpho13158443_morpho
morro73216953_mor_ro
morros83714673_morros_
mors65950063_mor_s_
morse76032703_mor_se
morts75533563_morts_
mosso74715183_mo_sso
mozos165516333_mozos_
nitroso7326453nitroso
olorosos844113olorosos
porose84818743_porose
proso77222413__proso
smoosh11236733smo_osh
toros54336193_toros_
torose64317693_torose
torso56922143_tor_so
vamoose1235863vamo_ose
vigoroso1242193vigoroso

Search took 9 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.1561145455.1
2DLD Change Limit134027817.95316852.4
3Display Results81810.0302700.0
 (SQL Overall)178691818.13921954.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.