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

46 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
medusans114414(None) 
medusan1044711medusan_
medusas1036211medusa_s
medians103214212med_ians
medusa936292medusa__
medusae1044762medusa_e
medusal1035182medusa_l
messans92710462me_ssans
bedpans1237173bed_pans
beduins1039123bedu_ins
cedulas1058503cedula_s
dedans85915073ded__ans
hexosans1844113hexosans
means75831233me___ans
medakas1435763medaka_s
medals94218053med__als
medevacs1643373medevacs
medials103914733med_ials
median94117543med_ian_
mediant103516703med_iant
mediants11299493med_iants
medias93620783med_ia_s
medicals1349363medicals
medicant13910833medicant
medicants1466783medicants
medigaps1463883medigaps
medinas103411463medina_s
medivacs1644003medivacs
medlars10259443med_lars
medullas1144513medullas
medusoid1242603medusoid
medusoids1341873medusoids
mensas85115863me_nsa_s
mesas76823203me__sa_s
mesons83215843me__sons
messan83912063me_ssan_
mezuzahs2141353mezuzahs
mezuzas1743233mezuza_s
modulars1165833modulars
perusals1047143perusals
recusals1056393recusals
recusant1049463recusant
recusants1145103recusants
redans75421023red__ans
refusals1164913refusals
sedans74816093sed__ans

Search took 8 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 Filter1786911461620.440406115.9
2DLD Change Limit146162467.25020160.3
3Display Results46460.0133538.5
 (SQL Overall)178691467.70323197.6
 
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.