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

93 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
medicare134748(None) 
medicares1446871medicares
medicate13513241medicate
dedicate12312802dedicate
mediae94217412medi_a_e
mediate103415212medi_ate
medicable1647502medicable
medicaid1445782medicaid
medical12312512medica_l
medicals1349362medicals
medicant13910822medicant
medicated15410072medicated
medicates14312112medicates
medicide1447712medicide
medicine1349542medicine
mediocre1343472mediocre
meditate11310622meditate
pedicure1345182pedicure
abdicate1348903abdicate
aldicarb1342903aldicarb
decare93919153__decare
deciare10710663deci_are
dedicated14310253dedicated
dedicatee13410343dedicatee
dedicates13311693dedicates
delicate11315493delicate
educate10310213_educate
epicarp1376073_epicarp
epicure1136823_epicure
indicate11313353indicate
manicure1245803manicure
media84721713medi_a__
mediacies1447183mediacies
mediacy1536143medi_acy
mediad104313713medi_a_d
medial93819863medi_a_l
medials103914733medi_als
median94117543medi_a_n
medians103214213medi_ans
mediant103516703medi_ant
medias93620783medi_a_s
mediated123011873medi_ated
mediates112814063medi_ates
medic104619653medic___
medicaids1544003medicaids
medically17310113medically
medicament1744883medicament
medicants1466783medicants
medicides1556583medicides
medicined1545113medicined
medicines1447903medicines
medick154010133medic__k
medicks16368413medic_ks
medico113711163medic__o
medicos12339833medic_os
medics114115353medic__s
medigap1374623mediga_p
medigaps1463883medigaps
medina94114093medina__
medinas103411463medina_s
meditated1348083meditated
meditates1239813meditates
medivac1554693mediva_c
medivaced1843133medivaced
medivacs1644003medivacs
medlar93010463med_lar_
medlars10259443med_lars
medusae1044763medusa_e
mendicant1466533mendicant
meniscate1346213meniscate
mesocarp1443983mesocarp
meticais1248183meticais
metical11315363metica_l
meticals12310763meticals
metricate1349913metricate
minicar11109313minicar_
minicars12118513minicars
modica11310063modica__
muricate12311113muricate
musicale1247343musicale
pedicab1446693pedica_b
pedicabs1544593pedicabs
pedicle1238973pedic_le
pedicured1543593pedicured
pedicures1445263pedicures
pericarp1446123pericarp
predicate14411773predicate
radicate11412873radicate
rediae74221993redi_a_e
redictate1249063redictate
redware1139353red_ware
vesicae12177703vesica_e
vesicate131210053vesicate

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.1531167915.0
2DLD Change Limit146162937.23620199.3
3Display Results93930.0303100.0
 (SQL Overall)178691937.41924085.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.