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

60 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
amphora144692(None) 
amphorae1546261amphorae
amphoral1565621amphoral
amphoras1547081amphoras
alphorn1246392alphorn
anaphora1345112anaphora
camphor1636132camphor_
camphors1737052camphors
abhor10411063a_bhor_
abhors11410623a_bhors
agora6914333a__gora
alpha1049653alph__a
alphorns1345223alphorns
althorn1047763althorn
amatory1238623amatory
amoral8314633am__oral
amort75832203am__ort
ampere10514413amp_ere
amphibia1744403amphibia
amphigory2051913amphigory
amphioxi2252303amphioxi
ampler104313303ampler_
ampulla1164303ampulla
anaphor1245653anaphor_
anaphoral1443803anaphoral
anaphoras1445383anaphoras
anaphors1346633anaphors
anchor113911973anchor_
anchors123912953anchors
angora71111573a_ngora
aphonia122711883a_phonia
aphtha1444483a_phtha
apnoea867093a_pnoea
aporia8315863a_p_oria
aport75432173a_p_ort
ashore9414613a_shore
aurora6411763a_urora
author939763author_
authors10311853authors
camphire1745893camphire
camphol1645793campho_l
camphols1746243camphols
camphorate19124963camphorate
camphoric2045483camphoric
cataphora16143613cataphora
emporia1148753emp_oria
ephor10310013_ephor_
ephoral1248403_ephoral
ephori1139603_ephori
ephors11311403_ephors
euphoria13116863euphoria
hora76136563___hora
implore11176703implore
import102713763imp_ort
lymphoma2053663lymphoma
mora66641273_m__ora
ramshorn1343923ramshorn
samphire1545833samphire
senhora10348673senhora
tephra1136483teph_ra

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.423422437.4
2DLD Change Limit134027605.73323378.2
3Display Results60600.0163750.0
 (SQL Overall)178691606.17228951.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.