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

65 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
medicaid144578(None) 
medicaids1544001medicaids
mediad104313712medi_a_d
medical12312512medica_l
medicals1349362medicals
medicant13910832medicant
medicare1347482medicare
medicate13513242medicate
medicated15410072medicated
medicide1447712medic_ide
meticais1248182meticais
dedicate12312803dedicate
dedicated14310253dedicated
diacid10310633__diacid
ericoid1049893_ericoid
helicoid1446753helicoid
media84721713medi_a__
mediacies1447183mediacies
mediacy1536143medi_acy
mediae94217413medi_a_e
medial93819863medi_a_l
medials103914733medi_als
median94117543medi_a_n
medians103214213medi_ans
mediant103516703medi_ant
medias93620783medi_a_s
mediate103415213medi_ate
mediated123011873mediated
medic104619653medic___
medicable1647503medicable
medically17310113medically
medicants1466783medicants
medicares1446873medicares
medicates14312113medicates
medicating1648953medicating
medication15411173medication
medicides1556583medic_ides
medicine1349543medicine
medicined1545113medicined
medick154010133medic__k
medicks16368413medic_ks
medico113711163medic__o
medicos12339833medic_os
medics114115353medic__s
medigap1374623mediga_p
medigaps1463883medigaps
medii84513493medi__i_
medina94114093medina__
medinas103411463medina_s
meditate11310623meditate
meditated1348083meditated
medivac1554693mediva_c
medivaced1843133medivaced
medivacs1644003medivacs
medusoid1242603medusoid
mendicant1466543mendicant
meniscoid1443313meniscoid
mermaid1297853me_rmaid
metical11315363metica_l
meticals12310763meticals
modica11310063modica__
pedicab1446693pedica_b
pedicabs1544593pedicabs
pedicled1436463pedicled
radicand12115283radicand

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.406440125.6
2DLD Change Limit146162657.17020385.2
3Display Results65650.0164062.5
 (SQL Overall)178691657.59223536.7
 
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.