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

63 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
mueddin114342(None) 
mueddins1243481mueddins
mudding123310812mu_dding
muezzin1742702muezzin
bedding124114483_bedding
beduin939713_beduin
budding123712403bu_dding
cuddie104011173cu_ddie
duddie9348863du_ddie
embedding1643313embedding
guerdon944343guerdon
hoddin11369933_hoddin
imbedding1643243imbedding
madden103912523m_adden
madding123711993m_adding
maudlin1037153maudlin
meddle103312763m_eddle
meddling13257933m_eddling
media84721713m_e_dia
median94117543m_edian
medic104619653m_e_dic
medii84513493m_e_dii
medina94114093m_e_dina
melding113414273m_elding
mending114018683m_ending
merlin83916683m_erlin
midden104112853m_idden
mucin93116823mu__cin
mudded114511383mu_dded
mudder104413493mu_dder
muddied12339213mu_ddied
muddier114110013mu_ddier
muddies113513943mu_ddies
muddily1435963mu_ddily
muddle103414633mu_ddle
muddling13268593muddling
muddly13418603mu_ddly
muddy123812233mu_dd_y
muddying16254543muddying
mudhen1236883mu_dhen
muesli835183muesli_
mueslis935493mueslis
muezzins1842663muezzins
muffin14298873mu_ffin
mullein9278563mullein
muntin82915183mu_ntin
murein8311763mu_rein
murrain937753murrain
muslin8312213mu_slin
myelin1138963mye_lin
pudding124010803pu_dding
quadding2035363quadding
redden83613613_redden
redding103218513_redding
redfin10310223_redfin
shedding14278113shedding
sledding11248503sledding
snedding11246953snedding
sudden83310833su_dden
sueding92613753sue_ding
tedding103210883_tedding
verdin103113023_verdin
wedding133411873_wedding

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.1561145455.1
2DLD Change Limit134027636.57620381.2
3Display Results63630.0331909.1
 (SQL Overall)178691636.76526414.0
 
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.