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

131 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
minae7562772(None) 
mina65136921mina_
minas75434111minas
mince95325231mince
mine67256171min_e
minke115421761minke
amine75835382amin_e
binal75323822binal
binate8419772binate
bine66650862bin_e
binge85125512binge
cine66242942cin_e
dinar66319892dinar
dine55555332din_e
dinge75627302dinge
final83922032final
finale94116762finale
fine75147952fin_e
hinge95323452hinge
imine75821062imin_e
inane52820342_inane
kina85632002kina_
kinas95626912kinas
kinase104210652kinase
kine85643432kin_e
laminae93512972laminae
liane54720662liane
linac7315412linac
linage7713402linage
line46965572lin_e
mae57659112m__ae
mana65341962mana_
manage93818902manage
manas76240432manas
manat76039992manat
mane65052032man_e
mange84930192mange
manse75528232manse
meinie82614522meinie
menace103216942menace
menad85918982menad
menage93216542menage
mensae84114052mensae
mense75025632mense
mica86428252mica_
micas96823052micas
mice87442232mi_ce
miche126219242miche
midge95016552midge
mike105535292mi_ke
milage93414122milage
mile66352572mi_le
mille75029132mille
mime85736402mi_me
minable112315072minable
minaret9520682minaret
minced114114912minced
mincer104017362mincer
minces104420802minces
mincy125817412mincy
mind75434382min_d
minded103817832minded
minder94822502minder
minds85427122minds
mined85333352mined
miner76933542miner
mines75651952mines
mingle93518782mingle
mingy115520182mingy
mini65634562min_i
minim97321602minim
minis75432992minis
mink106636532min_k
minkes124618782minkes
minks115829272minks
minny104518662minny
minor74920062minor
mint66758062min_t
mintage101110122mintage
minted94220582minted
minter84425102minter
mints76834042mints
minty106323902minty
minuet82621032minuet
minus75223932minus
minute83414292minute
minx137723352min_x
minxes154612982minxes
minyan1138172minyan
mirage92313652mirage
mire66748232mi_re
misate81222692misate
mise66043582mi_se
misname11119482misname
mite66249412mi_te
mitre75522422mitre
monad85519472monad
monas74732152monas
monde85723142monde
monie75631652monie
monte75829772monte
morae75831192morae
myna95815302myna_
mynah13569562mynah
mynas105815232mynas
nae35952742__nae
nine45842172nin_e
pina65842632pina_
pinas75434452pinas
pine67755712pin_e
pinnae84414642pinnae
rinse54820972rinse
since75024172since
sine46560622sin_e
singe65731132singe
tine45855132tin_e
tinea54923162tinea
tinge64626622tinge
ulnae55214572ulnae
venae85920982venae
vina76331802vina_
vinal85725812vinal
vinas85126342vinas
vine75643682vin_e
vitae84217632vitae
wince105220882wince
wine74953422win_e
winze175014852winze
yince105214252yince
zine137036152zin_e
zonae145116442zonae

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.313570897.8
2DLD Change Limit538001311.61033416.1
3Display Results1311310.0462847.8
 (SQL Overall)1786911311.96990752.2
 
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.