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 “butterier” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
butterier117745(None) 
butteries11711761butteries
batterer102713212batter_er
batterie10711532batterie_
batteries11615112batteries
bitterer10309772bitter_er
butleries11710072butleries
butterbur1342922butterbur
buttered112712622butter_ed
butteriest1276882butteriest
buttering122312522buttering
jitterier1644432jitterier
mutterer10218912mutter_er
putterer10209912putter_er
utterer71910462_utter_er
austerer838383auster_er
banterer102811773banter_er
barterer102711633barter_er
battener10369393batte_ner
battered113315053batter_ed
batterers113110713batter_ers
battering122715143battering
battier93515713batt__ier
beerier93613023b__eerier
bettered113011833better_ed
bettering122212753bettering
bittered112711833bitter_ed
bittering122511993bittering
bitterish1446133bitterish
bittier94211663bitt__ier
blusterer11176293bluster_er
booteries11312773booteries
buggeries1347083buggeries
bullbrier1343683bullbrier
bullterrier1351823bullterrier
burier84324653bu___rier
burrier93613553bu__rrier
bustier93916153bust__ier
butcherer1643753butcher_er
butcheries1745073butcheries
butter84724233butt___er
butterburs1443153butterburs
buttercup1542263buttercup
butterfat1444093butterfat
butterfish1853273butterfish
butterflied1752003butterflied
butterflies1652653butterflies
butterfly1742953butterfly
butterflyer1951313butterflyer
butterless1244193butterless
buttermilk1851963buttermilk
butternut1144743butternut
butters94521723butter__s
butterweed1643053butterweed
butterwort1554563butterwort
buttery124311193butter__y
butties93217953butt__ies
buttoner1036973butt_oner
catteries11815523catteries
cutesier1045623cu_tesier
cutleries1179213cutleries
fetterer11207813fetter_er
flutterer12185263flutter_er
guttered10259163gutter_ed
guttering112410443guttering
guttier83911103gutt__ier
letterer8259223letter_er
litterer82810173litter_er
lotteries9311073lotteries
muttered112610793mutter_ed
mutterers11247373mutter_ers
muttering122611323muttering
nuttier73112023nutt__ier
patterer103112173patter_er
potterer102310263potter_er
potteries11313593potteries
puckerier1754313puckerier
putrefier1443123putrefier
puttered112611143putter_ed
putterers11238363putter_ers
puttering122611643puttering
puttier93314503putt__ier
querier16310013qu__erier
rubberier1344393rubberier
ruttier73412283rutt__ier
skitterier1442423skitterier
sputterer11165263sputter_er
stutterer9164913stutter_er
sultrier837773sult_rier
summerier1346423summerier
titterer8268523titter_er
totterer8217793totter_er
ulterior845443_ulterior
uttered82712433_utter_ed
utterers8218653_utter_ers
uttering91613083_uttering
waterier11312083_waterier
winterier1238333winterier

Search took 8 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 Filter1786911486410.1561145455.1
2DLD Change Limit148641987.42020032.5
3Display Results98980.0462130.4
 (SQL Overall)178691987.62223444.1
 
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.