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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
yammering173519(None) 
hammering1737631hammering
mammering1337331mammering
cambering16109872cambering
hampering1738862hampering
pampering1638382pampering
simmering1467822simmering
stammering1544522stammering
summering1458752summering
tampering1438452tampering
yabbering1734022yabbering
yattering132410452yattering
adhering1338883_adhering
admiring1236133_admiring
altering91917123_altering
amberina1247403_amberina
amercing1337193_a_mercing
angering102113803_angering
armoring1149123_armoring
badgering1436973badgering
bamming144611813bamm__ing
bannering12208813bannering
bantering122414243bantering
barbering14229693barbering
bartering122313653bartering
battering122715153battering
bumpering1636593bumpering
cameoing1379063ca_meoing
cankering162110793cankering
cantering122417383cantering
capering132414963ca_pering
careering12311203careering
catering112019913ca_tering
chambering20116043chambering
chamfering21125333chamfering
clambering1776163clambering
commercing1955973commercing
compering163414163compering
cumbering16108203cumbering
dackering1737393dackering
daggering13246113daggering
daikering1536103daikering
damming133812743damm__ing
dampening1535463dampening
dandering122511063dandering
dangering12239303dangering
faltering132211123faltering
fathering161010093fathering
gamming133112623gamm__ing
gammoning1545063gammoning
gandering122111293gandering
garnering11298093garnering
gartering112111593gartering
gathering1499463gathering
glimmering1643713glimmering
haltering132212013haltering
hamming153014093hamm__ing
hamstring1546003hamstring
hankering17239383hankering
havering152211053ha_vering
homering141512073_homering
immerging1544103_immerging
immersing1445123_immersing
immuring1335533_immuring
jabbering2134443jabbering
jamming19329793jamm__ing
kashering1736253kashering
laagering1136833laagering
lackering1639383lackering
laddering1237593laddering
lagering102212313la_gering
lamming123014583lamm__ing
lappering14258843lappering
lathering13912253lathering
laveering1336813laveering
lawyering1655213lawyering
layering122310353la_yering
limbering1488793limbering
lumbering14117933lumbering
mastering122315313mastering
mattering122314063mattering
nattering102212223nattering
numbering14107003numbering
paltering122612903paltering
pandering133211963pandering
papering132213313pa_pering
pattering122314433pattering
paupering1437273paupering
pommeling1643873pommeling
pummeling1643603pummeling
ramming123115063ramm__ing
rehammering1953363rehammering
sabering112113743sa_bering
saggering12197793saggering
scampering1745323scampering
shimmering1884623shimmering
simpering1449293simpering
tabering112211423ta_bering
tapering112112503ta_pering
tattering102212333tattering
tempering1438733tempering
timbering14117723timbering
trammeling1544023trammeling
umbering1399433_umbering
wafering15208893wa_fering
wagering13219523wa_gering
waitering13310723waitering
wandering143310983wandering
watering122316323wa_tering
wavering152410543wa_vering
yammer133713183yammer___
yammered16225763yammer_ed
yammerer15225483yammer_er
yammerers16214453yammerers
yammers143410323yammer__s

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.453394461.4
2DLD Change Limit1486411156.82621775.7
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.32524394.7
 
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.