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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

95 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
ayah10802299(None) 
aah616252961a_ah
amah98927481amah
ayahs116813521ayahs
rayah116013501rayah
yah99046351_yah
aa219179952a_a_
aahs716428562a_ahs
aal39058672a_al
aas310975392a_as
aba512850952aba_
abas68642082abas
abash106016512abash
afar76720782afar
aga410447232aga_
agar58726412agar
agas55938842agas
agha87417302agha
ah513868792__ah
aha611246642aha_
ajar116217702ajar
ala312463602ala_
alae45643752alae
alan46844082alan
alar46340072alar
alas46358122alas
aliyah12397492aliyah
almah106917252almah
ama510853302ama_
amahs107819062amahs
amas67746292amas
ana39559822ana_
anal48037522anal
anas46649862anas
ankh111114412ankh
arak86929572arak
arch98628442arch
ash67944602a_sh
atap66722452atap
ava610139322ava_
awa611939672awa_
awash116613162awash
away108024222away
axal116520492axal
ay511773892ay__
aye67151762ay_e
ayes76543512ayes
ayin76331742ayin
ays67050292ay_s
azan136521782azan
bah87755352_bah
blah98625062blah
cyan96419622cyan
dah78148982_dah
dyad96415452dyad
eyas76427432eyas
galah95917622galah
gayal9312712gayal
hah910655222_hah
kayak1138362kayak
kyak105213632kyak
kyar116916842kyar
kyat116025522kyat
lych126015762lych
maya95824582maya_
mayan105616902mayan
mayas105924382mayas
mynah13569562mynah
myth126715432myth
nah69847002_nah
odah87018932odah
opah96218402opah
pah88853592_pah
pya87023752pya_
pyas96225702pyas
rah68052402_rah
rajah155711422rajah
raya75224822raya_
rayahs12579192rayahs
rayas85922052rayas
rya67622012rya_
ryas77224612ryas
shah105627782shah
syph125413272syph
wych154011882wych
ya510251502_ya_
yag76947732_yag
yak107038562_yak
yam87448992_yam
yap85949822_yap
yar67253832_yar
yaw97145152_yaw
yay96948712_yay
yeah106725412yeah
yeh97135772_yeh

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.1431249587.4
2DLD Change Limit29872951.01329488.6
3Display Results95950.0332878.8
 (SQL Overall)178691951.189150286.8
 
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.