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

168 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
midcap133647(None) 
madcap1336331madcap
mudcap1335131mudcap
giddap1143412giddap
kidnap1334192kidnap
madcaps1435242madcaps
mica86428252mi_ca_
micas96823052mi_cas
midday13327502midday
midway15327152midway
mishap1338862mishap
mobcap1444112mobcap
mudcaps1444102mudcaps
mudcat11311202mudcat
redcap1158492redcap
aidman92410623aidman
becap114315053_becap
bicep115413543bi_cep
bitmap1235613bitmap
cap76758983___cap
circa9311403circa_
dap66652453__d_ap
didact10711203didact
finca104714503finca_
fincas113512073fincas
fiscal1139333fiscal
gelcap1136213gelcap
giddyap1541233giddyap
haircap14134753haircap
hiccup1554393hiccup
hubcap1553993hubcap
icecap1245223icecap
idea59122773_idea_
ideal65716393_ideal
ideas65919013_ideas
kidnaps1453323kidnaps
lidar6312723lid_ar
macaw12311763m_acaw
madam10316223mad_am
madman113712383madman
madras94316433madras
map77255123m___ap
mayhap1635233mayhap
mecca1139933mecca_
meccas1239493meccas
medal86221333med_al
media84721713media_
mediad104313713mediad
mediae94217413mediae
medial93819863medial
median94117543median
medias93620783medias
medical12312513medical
medigap1374623medigap
medlar93010463medlar
mescal104113483mescal
mezcal19367853mezcal
mic77647643mi_c__
mice87442233mi_c_e
miche126219243mi_che
mick126333433mi_c_k
micks135525373mi_cks
micra96214973mi_cra
micro94715993mi_cro
microcap1645583microcap
mics87435153mi_c_s
mid67354473mid___
midair937993midair
midcult1246303midcult
middays14335663middays
midden104112853midden
middle103414983middle
middy124812593mid_dy
midge95016553mid_ge
midges103516483midges
midget103718453midget
midgut103510053midgut
midi75628483mid__i
midis85923413mid_is
midland1136613midland
midleg1038553midleg
midrash1335423midrash
midrib1138243midrib
mids76541793mid__s
midship1546043midship
midst85922553mid_st
midsts95510053midsts
midways16386183midways
midyear1343343midyear
mihrab1335523mihrab
mikra114610313mikra_
mikvah18143473mikvah
milch124413373milc_h
milia72719573milia_
milpa92111403milpa_
milpas101710273milpas
mimbar1297493mimbar
mimical1339233mimical
mina65136923mi_na_
minae75627723mi_nae
minas75434113mi_nas
mince95325233minc_e
minced114114913minced
mincer104017363mincer
minces104420803minces
mincy125817413minc_y
minicab13177163minicab
minicam131110053minicam
minicamp16124063minicamp
minicar11109313minicar
minyan1138173minyan
mirza16410443mirza_
mirzas1738183mirzas
misact10316683misact
miscall1139643miscall
miscast11312413miscast
miscopy1636663miscopy
miscue10412223miscue
miscut10614813miscut
misdeal1037663misdeal
misdial1039643misdial
misdraw1345623misdraw
miseat82925703miseat
mishaps1438713mishaps
miskal123710263miskal
mislay113510683mislay
missal84314903missal
missay114112143missay
mitral81314323mitral
mixup1636773mi_xup
mobcaps1543463mobcaps
modal85919243mod_al
modica11310063modica_
mudcats1236223mudcats
mudflap1542183mudflap
mudra83912433mudra_
mudras94212263mudras
musca9311763musca_
muscae10410673muscae
muscat10314653muscat
nicad8312613ni_cad
nidal65217103nid_al
oidia6314953oidia_
oilcamp1343053oilcamp
oilcan837793oilcan
oilcup1044253oilcup
pica85831493pi_ca_
pical95524373pi_cal
picas94626523pi_cas
recap95718023_recap
redcaps1247073redcaps
riprap1055513riprap
siccan1037593siccan
sidecar1045233sidecar
skycap1742913skycap
tical76021493ti_cal
tidal64516443tid_al
tincal83913363tincal
tipcat10312653tipcat
toecap1037323toecap
uncap9312283_uncap
vicar10513863vi_car
vinca105315163vinca_
vincas113912453vincas
wicca1247253wicca_
wiccan1335033wiccan
wiccas1336543wiccas
wildcat1346293wildcat

Search took 6 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 Filter1786911127160.453394461.4
2DLD Change Limit1127161685.33021147.5
3Display Results1681680.0463652.2
 (SQL Overall)1786911685.82930655.5
 
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.