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

162 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
minimal11401060(None) 
minima105512651minima_
minimals12327431minimals
minimax18376011minimax
animal85016252_animal
finial92814182fini_al
finical1239692finical
intimal9109942_intimal
maximal18347092maximal
menial84223032meni_al
miasmal1176742miasmal
mimical1339232mimical
mineral9312732mineral
minibar11106132minibar
minicab13177162minicab
minicam131110052minicam
minicar11109312minicar
minilab11126002minilab
minim97321602minim__
minimally1645902minimally
minimill1244482minimill
minims104514812minim_s
minimum10456142minimum
minivan1245712minivan
anima74620073_anima_
animals94111703_animals
animas84418723_animas
binal75323823bin__al
binomial1246223binomial
cinema1047653cinema_
cinemas1138043cinemas
clinical1247023clinical
conical11316203conical
cynical1437873cynical
decimal1238083decimal
denial74720513deni_al
digital937063digital
dismal92412243di_smal
dominical1446003dominical
filial93013253fili_al
final83922033fin__al
finials103210153fini_als
genial74917613geni_al
genital849793genital
gimmal11247513gi_mmal
gingal81010153gin_gal
gingival1342943gingival
hiemal11339503hi_emal
ilial55317843_ili_al
incisal947373_incisal
inia45024703_ini_a_
inimical1247313_inimical
initial7311883_initial
instal6712193_instal
intima81910033_intima_
intimae9109753_intimae
intimas9119583_intimas
invital1046953_invital
jingal1498593jin_gal
kinema1236023kinema_
kinemas1336893kinemas
kinsman1335963kinsman
lanital7310913lanital
liminal93810673liminal
lineal65616023lin_eal
lineman939123lineman
lingual8379083lingual
linkman1335393linkman
magical1239783magical
mammal95112753m_ammal
mania75634153mani_a_
maniac103917973mani_ac
maniacal1246723maniacal
manias84029033mani_as
manila84518303manila_
manilas93915873manilas
manilla93012473manilla
manual8313463man_ual
marital92314183marital
matinal9312603matinal
maxima17568633maxima_
maximals19325223maximals
medial93819863medi_al
medical12312513medical
menials94015683meni_als
meniscal1246193meniscal
mensal84615653men_sal
mental84521603men_tal
mesial84818083mesi_al
metical11315363metical
miasma1097563miasma_
miasmas1167743miasmas
milia72719573mili_a_
milkman1544913milkman
milligal1145703milligal
mina65136923min__a_
minae75627723min__ae
minas75434113min__as
mindful1344613mindful
minerals10311373minerals
mini65634563mini___
minibars1296553minibars
minibus1136343minibus
minicabs14135063minicabs
minicamp16124063minicamp
minicams14126863minicams
minicars12118513minicars
minify1439253mini_fy
minikin13258983minikin
minilabs12124573minilabs
minimalism13105043minimalism
minimalist14116493minimalist
minimaxes2043943minimaxes
minimills1343843minimills
minimise1246863minimise
minimize2146063minimize
minimums11404603minimums
mining94225453mini_ng
minings103912073minings
minion83416243mini_on
minions93314623minions
minipark1643543minipark
minipill1244353minipill
minis75432993mini__s
minish115216303mini_sh
miniski1344483miniski
minium106014423mini_um
miniums113910223miniums
minivans1345413minivans
miniver1238393miniver
minutial1046423minutial
minyan1138173min_yan
misdeal1037663misdeal
misdial1039643misdial
miskal123710263mi_skal
missal84314903mi_ssal
mistral91013643mistral
mitral81314323mi_tral
monadal1047893monadal
monomial12410133monomial
musical1139553musical
nidal65217103__nidal
nival84915773__nival
oinomel946353oinomel
optimal1145783optimal
penial84120893peni_al
pineal84817683pin_eal
pinitol936683pinitol
pinnal84814273pin_nal
primal104014623_primal
subminimal1652783subminimal
tibial849843tibi_al
tincal83913363tin_cal
tineal66216163tin_eal
tinman82411143tin_man
venial94218283veni_al
vicinal12268543vicinal
viminal12288823viminal
vinal85725813vin__al
vineal94814743vin_eal
wingman1336383wingman
xenial133414903xeni_al

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.1561145455.1
2DLD Change Limit1340271625.86022871.5
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.07929394.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.