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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

197 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
medicos1233983(None) 
medicks16368411medicks
medico113711161medico_
medics114115351medic_s
edicts94911702_edicts
medials103914742medials
medians103214212medians
medias93620782medi_as
medic104619652medic__
medical12312512medical
medicals1349362medicals
medick154010132medic_k
medinas103411462medinas
mediums12308722mediums
medius93613282medi_us
mendigos12425212mendigos
merinos9311982merinos
addicts1176013addicts
adios65822863_adi_os
aediles83413903aediles
alnicos985533alnicos
asdics9439863asdic_s
audios72312283audi_os
bedecks1635793bedecks
bedims1149593bedi_ms
bedticks1774163bedticks
bodices12710593bodices
calicos113913493calicos
cedis84317083cedi__s
chicos134614833_chicos
codices12512583codices
decos85522123__decos
deduces1168793deduces
deducts1166593deducts
deices94119373de_ices
delicts104012253delicts
depicts12358463depicts
deticks1437353deticks
devices133212583devices
dices86434243__dices
dicks125824693__dicks
dicot85429093__dicot
dicots94915793__dicots
didos76820813__didos
dinos65428063__dinos
discos94915213__discos
edict84722283_edic_t
ediles74016983_ediles
editor738663_editor
editors839423_editors
edits65819033_edi_ts
educes94011953_educes
educts9439893_educts
eidos65817753_e_idos
emetics11610723emetic_s
epics95014283_epic_s
ericas8315463_ericas
evicts11368553_evicts
helices12313723helices
helicon1237643helicon
helicons1337613helicons
helios94816633heli_os
herdics13249523herdic_s
indices103513443indices
indicts103210723indicts
indigos9347823indigos
ladinos8389963ladinos
lexicon1643903lexicon
lexicons1743893lexicons
macacos1338083macacos
maduros1036303maduros
magics115311613magic_s
maledicts1443393maledicts
malices114316623malices
manics103919933manic_s
maniocs113611443maniocs
manitos9314053manitos
meccas1239493me_ccas
medakas1435763medakas
medals94218063med_als
meddles113213253meddles
media84721713medi__a
mediacies1447183mediacies
mediacy1536143mediacy
mediad104313713medi_ad
mediae94217413medi_ae
medial93819863medi_al
median94117543medi_an
mediant103516703mediant
mediants11299493mediants
mediate103415213mediate
mediates112814063mediates
mediator1139043mediator
mediators1248923mediators
medicaid1445783medicaid
medicaids1544003medicaids
medicant13910833medicant
medicants1466783medicants
medicare1347483medicare
medicares1446873medicares
medicate13513243medicate
medicates14312113medicates
medicide1447713medicide
medicides1556583medicides
medicine1349543medicine
medicines1447903medicines
medigap1374623medigap
medigaps1463883medigaps
medii84513493medi__i
medina94114093medi_na
mediocre1343473mediocre
medium113711623medi_um
medivac1554693medivac
medivacs1644003medivacs
medlars10259443medlars
medleys13115333medleys
meds75735363med___s
medusas1036213medusas
megilps1233563megilps
melic94722333melic__
melilot9311083melilot
melilots1046553melilots
melodicas1444853melodicas
memos95719113me__mos
menaces112715523menaces
mendigo11506333mendigo_
mendings12338303mendings
menials94015693menials
meniscus1243783meniscus
menudos1034643menudos
merces105720743me_rces
mercies113817563mercies
mercs96020453me_rc_s
merino8315093merino_
merises93421423merises
merisis93213173merisis
merits8320873meri_ts
mesic93617863mesic__
mestinos1048163mestinos
mestizos1944493mestizos
meticais1248183meticais
metical11315363metical
meticals12310763meticals
metiers93312843metiers
metis75025903meti__s
metrics11312363metric_s
metros84217803me_tros
mezzos1635053me_zzos
micas96823053m__icas
micks135525373m__icks
micros104115363m__icros
mics87435153m__ic_s
midiron1046003midiron
midirons1145883midirons
midis85923413midi__s
milos75428013m__ilos
mimics1289363mimic_s
misos76523293m__isos
modica11310063modic_a
modicum1445073modicum
modicums1543483modicums
murices112612283murices
musicks15297053musicks
musics103911783music_s
muticous1246933muticous
myricas1436753myricas
pedalos10329703pedalos
pedicab1446693pedicab
pedicabs1544593pedicabs
pedicel1237813pedicel
pedicels1336253pedicels
pedicle1238973pedicle
pedicles1338683pedicles
pedros9312183ped_ros
pepinos1137693pepinos
predicts1339613predicts
radices102314263radices
radios74018673radi_os
redacts10510943redacts
redials84416883redials
redias74523603redi_as
redips93713843redi_ps
redocks14409933redocks
redos65126763red__os
reduces10513343reduces
relics84517903relic_s
relicts94414593relicts
seccos1039923se_ccos
seduces1069283seduces
tedious838443tedious
tediums10266973tediums
telcos8710683te_lcos
verdicts1446013verdicts
vidicon1343783vidicon
vidicons1443863vidicons
wendigos13434553wendigos
zydecos2241903zydecos

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.403443402.0
2DLD Change Limit1340271976.22021547.7
3Display Results1971970.0802462.5
 (SQL Overall)1786911976.70326658.4
 
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.