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

100 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
mincers11371484(None) 
mincer104017361mincer_
minces104420801mince_s
minders103720111minders
miners84126631min_ers
minters93822461minters
pincers113916501pincers
wincers123415361wincers
binders103920742binders
biners85023632bin_ers
bingers104519992bingers
cancers114018582cancers
cinders104617752cinders
dancers103413092dancers
dicers94720742di_cers
diners75525952din_ers
dingers94321382dingers
dinners83915442dinners
fencers123810622fencers
finders113717872finders
fingers113418432fingers
gingers94118642gingers
ginners84314222ginners
hinders113718502hinders
hingers113420202hingers
hinters103719572hinters
inchers123912522_inchers
incurs83012272_incurs
infers93615442_infers
inkers104018832_inkers
inners63919352_inners
inters64328042_inters
jinkers183511812jinkers
lancers93616642lancers
liners65428852lin_ers
lingers84223302lingers
linkers114317712linkers
linters73822622linters
macers105321272m_acers
mangers103521262mangers
manners93417832manners
menacers12279302menacers
menders103818802menders
mercers114412772mercers
milers84625162mi_lers
milkers134411612milkers
millers93621332millers
milters93619082milters
mimers105520182mi_mers
mince95325232mince__
minced114114912mince_d
mincier113512462mincier_
minder94822502minder_
miner76933542min_er_
mines75651952min_e_s
minglers113011292minglers
minicars12118502minicars
minivers1337472minivers
minkes124618782minke_s
minors85117092min_ors
minsters103813912minsters
minter84425102minter_
minuets9259852minuets
minxes154612982minxe_s
misers85025702mi_sers
misters93927502misters
miters84328772mi_ters
mithers123516732mithers
mixers154513562mi_xers
mongers104217272mongers
munchers15318772munchers
piecers114112252piecers
pincer104019172pincer_
pinchers153510612pinchers
pinders103720472pinders
pingers104020742pingers
pinkers134118602pinkers
pinners93518602pinners
ricers84120992ri_cers
ringers83922952ringers
rinsers73815742rinsers
sincere9310552sincere
singers83824702singers
sinkers113618542sinkers
sinners74019022sinners
sinters74024072sinters
tinders84219172tinders
tinkers113517142tinkers
tinners73717312tinners
tinters74221102tinters
wincer115018192wincer_
winces114819112wince_s
winceys15395522winceys
winchers16319222winchers
winders113721262winders
wingers113921482wingers
winkers143517112winkers
winners104316912winners
winters103720472winters
zingers173514852zingers

Search took 6 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 Filter1786911076710.1401276364.3
2DLD Change Limit1076711004.81322370.9
3Display Results1001000.0601666.7
 (SQL Overall)1786911005.01335645.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.