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

146 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
mimical133923(None) 
comical13312222comical
domical1239372domical
finical1239692finical
inimical1247312inimical
liminal93810672liminal
magical1239782magical
medical12312512medical
metical11315362metical
mimic111414322mimic__
mimicry1643492mimicry
mimics1289362mimic_s
minicab13177162minicab
minicam131110052minicam
minicar11109312minicar
minimal114010602minimal
musical1139552musical
viminal12288822viminal
admiral1046363admiral
apical10913903_apical
atomical1248903atomical
biblical1445923biblical
bifocal1445373bifocal
bimetal1138433bimetal
bimodal1245663bimodal
biotical1248863biotical
chemical1748393chemical
cimices13279803cimices
clinical1247023clinical
conical11316203conical
cosmical1448013cosmical
criminal1248303criminal
critical12310263critical
cubical1338463cubical
cynical1437873cynical
deifical1445543deifical
digital937063digital
domicil1246433domicil
dominical1446003dominical
empirical1544193empirical
epical10413393_epical
ethical1238443ethical
filial93013253fili_al
finial92814183fini_al
fiscal1139333fi_scal
geminal10109903geminal
gimbal11228813gim_bal
gimmal11247513gim_mal
gnomical1346683gnomical
helical12311153helical
ilial55317843_ili_al
immoral1146783immoral
laical8312323_laical
laminal94113633laminal
lexical1637363lexical
limina83514503limina_
logical1038513logical
luminal93711003luminal
lyrical1236493lyrical
mammal95112753mam_mal
maniacal1246723maniacal
marital92314183marital
matinal9312603matinal
maximal18347093maximal
medial93819863medi_al
medicals1349363medicals
menial84223033meni_al
meniscal1246193meniscal
mescal104113483m_escal
mesial84818083mesi_al
meticals12310763meticals
metrical12311593metrical
mezcal19367853m_ezcal
miasmal1176743miasmal
mica86428253__mica_
micas96823053__micas
midcap1336473mi_dcap
milia72719573mili_a_
milligal1145703milligal
mimbar1297493mim_bar
mimicked1943253mimicked
mimicker1843313mimicker
miming114317263mimi_ng
mimosa1036363mimosa_
mimosas1136753mimosas
mineral9312733mineral
minibar11106133minibar
minicabs14135063minicabs
minicamp16124063minicamp
minicams14126863minicams
minicars12118513minicars
minilab11126003minilab
minima105512653minima_
minimals12327433minimals
minimax18376013minimax
minivan1245713minivan
miscall1139643mi_scall
misdeal1037663misdeal
misdial1039643misdial
miskal123710263mi_skal
missal84314903mi_ssal
mistral91013643mistral
miticidal1444183miticidal
mitral81314323mi_tral
modica11310063modica_
musicale1247343musicale
musicals1247093musicals
myrica1336833myrica_
myricas1436753myricas
mystical1546933mystical
mythical1845033mythical
nodical1049863nodical
nominal92712373nominal
optical1149863optical
pemican1348153pemican
pical95524373__pical
plical10411683_plical
radical103312793radical
ruminal9289993ruminal
seismical1344643seismical
seminal91213403seminal
silica8311243silica_
silicas9310603silicas
silvical1345223silvical
simian8811163simi_an
similar937853similar
simitar936733simitar
somital939403somital
stoical9310283stoical
tibial849843tibi_al
tical76021493__tical
timbal102510753tim_bal
timbral11237193timbral
tincal83913363ti_ncal
topical1139953topical
toxical1637643toxical
typical1436343typical
umbilical15113163umbilical
vatical1239983vatical
vesical12159813vesical
viatical1347063viatical
vicinal12268543vicinal
vimina11339943vimina_
vomica1336383vomica_
vomicae1445303vomicae
whimsical1952233whimsical

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271467.32618294.7
3Display Results1461460.0463173.9
 (SQL Overall)1786911467.52823736.8
 
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.