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

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

76 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
mayan10561690(None) 
maya95824591maya_
mayas105924381mayas
alan46844082_alan
ayah108022992_ayah
ayin76331742_ayin
azan136521782_azan
banyan1139482banyan
bayman133712712bayman
cayman133613222cayman
cyan96419622_cyan
daman84821172daman
gayal9312712gayal
hazan173813612hazan
japan14411232japan
jawan15710382jawan
kayak1138372kayak
lagan66520342lagan
lauan55216792lauan
layin84720332layin
layman113511312layman
maar66025062ma_ar
macaw12311762macaw
macon94519952macon
madam10316222madam
madman113712392madman
magian9312832magian
main65345522ma_in
makar115614972makar
malar76424442malar
mama86231602mama_
mamas95930782mamas
man57465872m__an
mana65341962mana_
manana84816072manana
manas76240432manas
manat76039992manat
manna75522542manna
mannan85413622mannan
mara67444582mara_
maras75443302maras
masa65034722masa_
masas75630412masas
mason74820182mason
matin75132852matin
maun65727212ma_un
maven104816892maven
mavin105722952mavin
mawn94424142ma_wn
may88757632may__
maybe12311132maybe
mayday1535882mayday
mayed115522402mayed
mayhap1635232mayhap
maying124421152maying
mayo96524302may_o
mayor106616622mayor
mayos105521932mayos
mays96940032may_s
mayst106622672mayst
mayvin1436522mayvin
mean65538092m_ean
minyan1138172minyan
moan65832022m_oan
myna95815302m_yna
naan47621932na_an
paean77222722paean
pagan86121162pagan
pavan106518472pavan
ratan53722662ratan
raya75224822raya_
rayah116013502rayah
rayas85922052rayas
rayon83815702rayon
saran53730312saran
zayin174512042zayin

Search took 6 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 Filter178691538000.296603685.8
2DLD Change Limit53800764.73611359.8
3Display Results76760.0135846.2
 (SQL Overall)178691765.04535419.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.