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

137 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
winced12441534(None) 
minced114114911minced
wince105220881wince_
wincer115018191wincer
winces114819111winces
wincey144110381wincey
winched163110591winched
winded114918211winded
wined94434181win_ed
winged114620831winged
winked144018601winked
winned104017011winned
zinced18419411zinced
binged105920822binged
binned94414542binned
cinched153910862cinched
danced105315252danced
diced95824682di_ced
dined76431992din_ed
dinged95221782dinged
dinked124818352dinked
dinned84317612dinned
dinted84419842dinted
disced104914652disced
dwined114610212dwin_ed
evinced1335402evinced
fenced124412712fenced
fined94930502fin_ed
finked144214622finked
finned104114602finned
ginned83813982ginned
hinged114618922hinged
hinted104318322hinted
iced78721892_i_ced
inched124514482_inched
inked104218522_inked
inned64118422_inned
jinked184013142jinked
jinxed21346082jinxed
kinged124215292kinged
kinked104014752kinked
lanced93717722lanced
lined64934642lin_ed
linked114518212linked
linted74021822linted
mince95325232mince_
mincer104017362mincer
minces104420802minces
minded103817832minded
mined85333352min_ed
minted94220582minted
oinked114213282oinked
pieced113912102pieced
pincer104019172pincer
pinched153812452pinched
pined85935322pin_ed
pinged104321382pinged
pinked134819882pinked
pinned94818382pinned
ponced114314812ponced
riced85825542ri_ced
rinded84418982rinded
ringed84623842ringed
rinsed75016352rinsed
sicced11489652sicced
since75024172since_
singed85422292singed
sinned73818412sinned
swinged123810792swinged
swinked15349032swinked
synced12266962synced
ticced11438442ticced
tincted1037272tincted
tined65434532tin_ed
tinged84220802tinged
tinned74317532tinned
tinted74419532tinted
twined104413122twin_ed
twinged12398362twinged
twinned11366332twinned
viced115118182vi_ced
vined95626152vin_ed
waned95831782wan_ed
wanked144517152wanked
wanned104318012wanned
wanted104319722wanted
wenched163910912wenched
wended113616152wended
whined134715202whin_ed
whinged15409152whinged
wicked164317412wicked
wifed125117742wi_fed
wigged124413582wigged
wilded113714502wilded
wiled95231552wi_led
willed104722452willed
wilted103915712wilted
wimped144211512wimped
wincers123415362wincers
winceys15395522winceys
winch135016662winc_h
wincher153410652wincher
winches154714372winches
wind85533852win__d
winder104025262winder
windled123713482windled
wine74953422win_e_
wines85546862win_es
winey115325432win_ey
winger104125442winger
winier94522452winier
winker134220292winker
winkled15299592winkled
winner94219932winner
winoes94317012winoes
winter94222802winter
wintled11339842wintled
winze175014852winze_
winzes184313052winzes
wiped114722082wi_ped
wired95327642wi_red
wised95123342wi_sed
wished134417512wished
wisped123411892wisped
wissed104114642wissed
wisted104120272wisted
witched163012192witched
wited94727142wi_ted
withed134416232withed
witted104216812witted
wived125121502wi_ved
wonned104012062wonned
wonted103213282wonted
wringed123710192wringed
yince105214252yince_
zincked2334232zincked
zinged174414622zinged

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 Filter178691825510.343520965.0
2DLD Change Limit825511372.33035429.6
3Display Results1371370.0462978.3
 (SQL Overall)1786911372.71965719.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.