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

103 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
mincy12581741(None) 
mince95325231mince
mingy115520181mingy
minny104518661minny
minty106323901minty
zincy195413511zincy
cinch124516242cinch
dingy105721262dingy
dinky135819372dinky
fancy134615482fancy
finca104714502finca
finch135416972finch
finny114716752finny
ginny95314572ginny
hinky155618752hinky
hinny115616672hinny
icy86322132_i_cy
inby95315662_inby
inch95420822_inch
inky115321582_inky
inly75622212_inly
kinky115816392kinky
lindy96918322lindy
liney87029632liney
lingy96925142lingy
linky127622382linky
linty87126562linty
liny78141332lin_y
mainly11411492mainly
mangy115021252mangy
manly105022952manly
many95731862man_y
meiny104015412mein_y
mercy125916182mercy
mic77647652mi_c_
mica86428262mi_ca
mice87442242mi_ce
mick126333442mi_ck
mics87435162mi_cs
middy124812602middy
miffy163910202miffy
milch124413372milch
milky144014442milky
milty104720072milty
mina65136932min_a
minae75627722minae
minas75434112minas
minced114114912minced
mincer104017362mincer
minces104420802minces
mind75434392min_d
minds85427132minds
mine67256182min_e
mined85333352mined
miner76933542miner
mines75651952mines
mini65634572min_i
minify1439252minify
minim97321602minim
minis75432992minis
mink106636542min_k
minke115421762minke
minks115829272minks
minor74920062minor
mint66758072min_t
mints76834042mints
minus75223932minus
minx137723362min_x
mirky146315522mirky
miry96326762mi_ry
missy105617562missy
misty106120452misty
mity95528222mi_ty
money104826842money
mony96830012mon_y
munch124917102munch
nancy105214922nancy
ninny84514932ninny
pinch125619302pinch
piney105727502piney
pinky145823402pinky
pinny105222062pinny
piny911838362pin_y
rindy95717402rindy
since75024172since
tinct76126232tinct
tinny85317652tinny
tiny76134642tin_y
vinca105315162vinca
viny106025962vin_y
wince105220882wince
wincey144110382wincey
winch135016662winch
windy126118112windy
winey115325432winey
wingy126521032wingy
winy107034332win_y
yince105214252yince
zinc156819102zinc_
zincky24404962zincky
zincs165312932zincs
zingy186516132zingy
zinky215314812zinky

Search took 3 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.360496363.9
2DLD Change Limit538001031.68631909.8
3Display Results1031030.0303433.3
 (SQL Overall)1786911032.07686074.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.