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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
minor7492006(None) 
manor78023931manor
miner76933541miner
minors85117101minors
amino75425502amino_
biner75930692biner
dinar66319892dinar
diner65632902diner
dino56036752dino_
dinos65428062dinos
donor64418192donor
finer85431562finer
fino76034692fino_
finos86226952finos
honor85718622honor
imino74315232imino_
inro45920792_inro
kino86233612kino_
kinos96626142kinos
liner55938922liner
lino46343372lino_
linos55631502linos
major145212922major
mano66536812mano_
manors84420882manors
manos74933622manos
mayor106616622mayor
meno66031362meno_
mentor8414362mentor
miaou7513082miaou
miaow1058352miaow
micro94715992micro
mignon937952mignon
miler75733062miler
milo65536102milo_
milord999572milord
milos75428012milos
mimer94825762mimer
mina65136922min_a
minae75627722minae
minas75434112minas
mince95325232mince
mincer104017362mincer
mincy125817412mincy
mind75434382min_d
minder94822502minder
minds85427122minds
mine67256172min_e
mined85333352mined
miners84126632miners
mines75651952mines
mingy115520182mingy
mini65634562min_i
minim97321602minim
minion83416242minion
minis75432992minis
mink106636532min_k
minke115421762minke
minks115829272minks
minnow1135582minnow
minny104518662minny
minorca1145222minorca
minored10310102minored
mint66758062min_t
minter84425102minter
mints76834042mints
minty106323902minty
minus75223932minus
minx137723352min_x
mir57046772mi__r
mirror848002mirror
miser75430402miser
miso67229902miso_
misos76523292misos
miter75734792miter
mixer145017642mixer
mono66036722mono_
monos75930862monos
moor66628552m_oor
mor56855002m__or
motor75317292motor
mucor94011942mucor
ninon55517382ninon
nor38048822__nor
pinon76024532pinon
pinot78737292pinot
rigor62714052rigor
senor53822792senor
signor73510352signor
spinor839942spinor
tenor53620252tenor
vigor92612422vigor
vino76128432vino_
vinos84723072vinos
visor82512832visor
vizor173010092vizor
wino75933612wino_
winos84625042winos

Search took 10 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.186960704.3
2DLD Change Limit53800987.8606844.8
3Display Results98980.0462130.4
 (SQL Overall)178691988.09222082.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.