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

53 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
buffeter168359(None) 
buffeted1753731buffeted
buffeters1783141buffeters
budgeter1244542budgeter
buffer144512682buff__er
buffered1764992buffered
buffet143113782buffet__
buffets15317592buffet_s
buffier1568402buff_ier
sufferer1436062sufferer
affecter1644523_affecter
baffler15418113baff_ler
beefeater1443603beefeater
billeter1037563billeter
biometer1239603biometer
bluffer15396883bluff__er
bucketed1736763bucketed
budgeted1344883budgeted
budgeteer1342773budgeteer
budgeters1343593budgeters
buffed154313143buff__ed
buffers153310793buffe_rs
buffest15298643buffe_st
buffeting1843783buffeting
bulleted1138393bulleted
bunter85020383bu__nter
burdener1136143burdener
burster9310293bu_rster
busheler1374753busheler
buster84726493bu__ster
butter84724233bu__tter
duffer134711663duff__er
effecter1664773_effecter
effete1235183_effete_
huffier1637493huff_ier
junketer1943713junketer
muffler15398343muff_ler
offerer1335543_offerer
puffer144610733puff__er
puffier1547973puff_ier
quieter162810333qu_ieter
ruffler13369723ruff_ler
rufflier1434013rufflier
suffer124314513suff__er
suffered1536733suffered
sufferers1555103sufferers
sufficer16225823sufficer
surfeiter1244713surfeiter
tuffet122612083tuffet__
tuffets13266523tuffet_s
tufter9319933tu_f_ter
unfetter1136753_unfetter
ureter6313203_u_reter

Search took 7 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 Filter1786911461620.420425454.8
2DLD Change Limit146162536.04624175.0
3Display Results53530.0163312.5
 (SQL Overall)178691536.48227567.3
 
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.