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

86 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
manat76039981manat
mina65136901mina_
minae75627721minae
minas75434111minas
mint66758041min_t
binal75323822binal
binate8419772binate
binit76431582binit
bint67355032bin_t
dinar66319892dinar
dint56759052din_t
fiat76646642fi_at
final83922032final
giant65430592giant
gnat56034432_gnat
hint77455742hin_t
ikat87626642_ikat
inapt73522692_inapt
kina85631992kina_
kinas95626912kinas
linac7315412linac
lint416266232lin_t
mana65341942mana_
manas76240422manas
manats84623462manats
manta75629902manta
mat58083932m__at
meant76537202meant
meat66359602m_eat
menad85918982menad
menta74424422menta
mica86428242mica_
micas96823052micas
midst85922552midst
might113827082might
milt65455802mi_lt
minaret9520682minaret
mince95325232mince
mincy125817412mincy
mind75434362min_d
minds85427122minds
mine67256152min_e
mined85333352mined
miner76933542miner
mines75651952mines
mingy115520182mingy
mini65634542min_i
minim97321592minim
minis75432982minis
mink106636512min_k
minke115421762minke
minks115829272minks
minny104518662minny
minor74920062minor
mints76834042mints
minty106323902minty
minuet82621032minuet
minus75223932minus
minute83414292minute
minx137723332min_x
minyan1138172minyan
misact10316682misact
misate81222692misate
miseat82925702miseat
mist66154522mi_st
mitt66145482mi_tt
mixt136831912mi_xt
moat66352032m_oat
monad85519472monad
monas74732152monas
myna95815292myna_
mynah13569562mynah
mynas105815232mynas
pina65842632pina_
pinas75434452pinas
pinata83817212pinata
pinot78737292pinot
pint66963172pin_t
pinta75727052pinta
qanat144426842qanat
riant55833152riant
tinct76126232tinct
tint46758862tin_t
vina76331802vina_
vinal85725812vinal
vinas85126342vinas

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 Limit53800861.67032215.6
3Display Results86860.0165375.0
 (SQL Overall)178691861.782100275.5
 
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.