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

110 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
weiner9421413(None) 
seiner64622481seiner
veiner94514751veiner
weaner93816771weaner
weiners103913061weiners
whiner124516631whiner
wiener94513541wiener
aliner65621992aliner
biner75930692_biner
briner84519042briner
ceiler84013962ceiler
coiner84323782coiner
definer114413772definer
deicer94114412deicer
denier74420692denier
diner65632902_diner
eider64624752_eider
fainer94717242fainer
feigner1135592feigner
finer85431562_finer
gainer74117492gainer
heifer1238202heifer
joiner134114132joiner
keener104012842keener
leaner64022192leaner
liner55938922_liner
meaner84617842meaner
miner76933542_miner
peined94918842peined
penner84616662penner
refiner105316912refiner
reined74425522reined
reinter73116842reinter
reiver95318292reiver
repiner94816902repiner
ruiner64013642ruiner
seine55732872seine_
seined74023062seined
seiners74219272seiners
seines65029902seines
seiser65318342seiser
seizer154114572seizer
shiner93820872shiner
teener64717502teener
tenner64117102tenner
tweener10306832tweener
twiner94012592twiner
vainer93714572vainer
veiler93814352veiler
veined104413912veined
veiners104112522veiners
veinier10269582veinier
wailer93720332wailer
waiter94321252waiter
waiver124212712waiver
wanier93920682wanier
wanner94019622wanner
warner93717222warner
weaker134015442weaker
weaned103816152weaned
weaners104613832weaners
wearer94319412wearer
weaver123916612weaver
weber10313522we_ber
wedder113612302wedder
weeder103315512weeder
weened104013732weened
weenier103210802weenier
weeper114313302weeper
weer75535092we__er
weever123811442weever
weigher14136342weigher
weir76019922wei__r
weirder1144922weirder
welder102914412welder
welter93417382welter
wennier10318602wennier
wester94222892wester
wether123315392wether
wetter93919442wetter
whine116022812whine_
whined134715202whined
whiners134011572whiners
whines125120102whines
whiney155012642whiney
whinger1410810912whinger
whinier134110632whinier
whiter124316392whiter
wider94826362w_ider
wieners103212482wieners
wincer115018192w_incer
winder104025262w_inder
wine74953432w_ine_
wined94434182w_ined
winery125014282w_inery
wines85546862w_ines
winey115325432w_iney
winger104125442w_inger
winier94522452w_inier
winker134220292w_inker
winner94219932winner
winter94222802w_inter
wiper105421292w_iper
wirer85124952w_irer
wiser85522802w_iser
wiver115924512w_iver
wonner95114442wonner
wrier84521752wri_er
wringer113612452wringer
writer94416512writer

Search took 4 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.346516448.0
2DLD Change Limit825511102.90328436.4
3Display Results1101100.0333333.3
 (SQL Overall)1786911103.28254445.8
 
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.