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

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

231 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
minis7543298(None) 
finis86824261finis
midis85923401midis
minas75434111minas
minds85427121minds
mines75651951mines
mini65634541mini_
minim97321591minim
minims104514801minims
minish115216291minish
minks115829271minks
mints76834041mints
minus75223931minus
mitis75425981mitis
munis75022001munis
ains46158882ain_s
amines84727982amines
aminic104413512aminic
amins75534312amin_s
anis45746462_anis
bidis86721142bidis
bindis94614582bindis
binds86627472binds
bines76946792bines
binit76431582binit
binits85716672binits
bins66548242bin_s
bints76130182bints
blinis85313682blinis
cines75239682cines
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042din_s
dints67431312dints
finds95424822finds
fines86644262fines
finish124613402finish
finks125424222finks
finos86226952finos
fins75849092fin_s
ginks104319562ginks
gins55543952gin_s
hinds96721472hinds
hins76447992hin_s
hints87330622hints
ibis66519562_ibis
imines84918342imines
impis96213832impis
inia45024692_inia
inks86926502_inks
inns46920932_inns
ins35945602_in_s
intis55121632_intis
iris45732542_iris
iwis77117002_iwis
jinks165019332jinks
jinnis13489052jinnis
jinns126013842jinns
jins115635012jin_s
kinas95626912kinas
kinds106221812kinds
kines95039132kines
kings105825562kings
kinin94917322kinin
kinins104014582kinins
kinks84926082kinks
kinos96626142kinos
kins85747902kin_s
kiwis12328582kiwis
lenis56326862lenis
lines57054572lines
lings67135772lings
linin58025522linin
linins65922142linins
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
mains75635092main_s
manas76240422manas
manes76648952manes
mania75634142mania
manias84029032manias
manic94629432manic
manics103919932manics
manos74933612manos
mans66354532man_s
mantis83926032mantis
manus75924922manus
mavis105622722mavis
maxis145721562maxis
meinie82614522meinie
meinies92516072meinies
mends84927692mends
menus75822842menus
metis75025902metis
mibs85330462mi_bs
micas96823052micas
micks135525372micks
mics87435142mi_cs
midi75628462midi_
mids76541772mi_ds
miens76118302miens
miffs134512872miffs
miggs96311372miggs
migs76935312mi_gs
mikes115129892mikes
milds86422052milds
miles74645072miles
milia72719562milia
milks115020582milks
mills75435052mills
milos75428012milos
mils66045322mi_ls
milts75430712milts
mimes95732022mimes
mimic111414312mimic
mimics1289352mimics
mina65136902min_a
minae75627722minae
mince95325232mince
minces104420802minces
mincy125817412mincy
mind75434362min_d
mine67256152min_e
mined85333352mined
miner76933542miner
miners84126632miners
mingy115520182mingy
minibus1136322minibus
minify1439242minify
minima105512632minima
mining94225442mining
minings103912072minings
minion83416232minion
minions93314622minions
miniski1344482miniski
minium106014412minium
miniums113910212miniums
mink106636512min_k
minke115421762minke
minkes124618782minkes
minnies93617362minnies
minny104518662minny
minor74920062minor
minors85117092minors
mint66758042min_t
minty106323902minty
minx137723332min_x
minxes154612982minxes
minxish1936212minxish
miosis83615162miosis
mips85534072mi_ps
mires75640882mires
miri66730362miri_
mirin75023142mirin
mirins83918892mirins
mirks115122142mirks
mirs66940562mi_rs
mis58162612m__is
mises74740562mises
misos76523292misos
miss65339412mi_ss
missis84417502missis
mists76633902mists
mites75141802mites
mitts75523752mitts
mixes147224402mixes
monas74732152monas
monie75631652monie
monies83233162monies
monish114217592monish
monism104016312monism
monist84324982monist
monks116123392monks
monos75930862monos
mons68152252mon_s
muni65824402muni_
muns65535912mun_s
mynas105815232mynas
nines55937342nines
oinks94819912oinks
ornis54616772ornis
penis75129322penis
pikis115116392pikis
pilis75825202pilis
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pins65558452pin_s
pints75936222pints
ranis55235832ranis
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192rin_s
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272sin_s
sinus55523852sinus
tikis95615972tikis
tines54848422tines
tings65329192tings
tins45251302tin_s
tints56030922tints
tipis76019922tipis
titis56023812titis
vinas85126342vinas
vines85137642vines
vinic10314972vinic
vinos84723072vinos
winds95425602winds
wines85546862wines
wings95727242wings
winish124212262winish
winks125325432winks
winos84625042winos
wins75949172win_s
yins75335122yin_s
yonis85020822yonis
zincs165312932zincs
zines145232652zines
zings154620892zings
zins135735002zin_s
zitis145815582zitis

Search took 2 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 Filter178691538000.0961861364.6
2DLD Change Limit538002311.45337026.8
3Display Results2312310.0603850.0
 (SQL Overall)1786912311.609111057.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.