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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
amah9892748(None) 
aah616252961a_ah
almah106917251almah
ama510853301ama_
amahs107819061amahs
amas67746291amas
ayah108022991ayah
aa219179952a_a_
aahs716428562a_ahs
aal39058672a_al
aas310975392a_as
aba512850952aba_
abas68642082abas
abash106016512abash
adman84517902adman
afar76720782afar
aga410447232aga_
agar58726412agar
agas55938842agas
agha87417302agha
agma77623262agma_
agmas85919872agmas
ah513868792__ah
aha611246642aha_
ajar116217702ajar
ala312463602ala_
alae45643752alae
alan46844082alan
alar46340072alar
alas46358122alas
alma66333022alma_
almahs118611612almahs
almas76629772almas
almeh106214552almeh
am411875562am__
amain74922882amain
amass77119682amass
amaze166016602amaze
ambo88225132ambo
amen66733152amen
ami56646802am_i
amia66836892amia
amias75831462amias
amid77036332amid
amie66339842amie
amin66042242amin
amir65129742amir
amis66445312amis
ammo85520132ammo
amok10217402amok
amp77541022am_p
amps86230342amps
amu58237322am_u
amus65529612amus
amyl95515092amyl
ana39559822ana_
anal48037522anal
anas46649862anas
ankh111114412ankh
arak86929572arak
arch98628442arch
ash67944602a_sh
atap66722452atap
atma68121772atma_
atman75520142atman
atmas75721012atmas
ava610139322ava_
awa611939672awa_
awash116613162awash
away108024222away
axal116520492axal
axman144813182axman
ayahs116813522ayahs
azan136521782azan
bah87755352_bah
bimah127013262bimah
blah98625062blah
camas96333522camas
dah78148982_dah
daman84821162daman
damar84117732damar
galah95917622galah
gama77035512gama_
gamas85431352gamas
gamay116419102gamay
hah910655222_hah
hamal104623102hamal
hamzah23135552hamzah
imam81718322imam
lama66635292lama_
lamas75532792lamas
ma410060652_ma_
maar66025052maar
mac78053922_mac
mach116134472mach
mad68958702_mad
mae57659102_mae
mag67956472_mag
mama86231582mama_
mamas95930772mamas
man57465852_man
map77255112_map
mar57965942_mar
mas58175812_mas
mash96039392mash
mat58083932_mat
math95437442math
maw87050092_maw
max129045442_max
may88757622_may
nah69847002_nah
odah87018932odah
opah96218402opah
pah88853592_pah
rah68052402_rah
rajah155711422rajah
ramal74622242ramal
rayah116013502rayah
shah105627782shah
smash104814432smash
tamal73522612tamal
yah99046352_yah
yeah106725412yeah

Search took 2 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 Filter178691298720.0632836365.1
2DLD Change Limit298721230.96630923.4
3Display Results1231230.0333727.3
 (SQL Overall)1786911231.062168258.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.