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

86 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
blatherer1417671(None) 
blathered15168351blathered
blatherers15175341blatherers
latherer111310441_latherer
batterer102713212b_atterer
blather125314202blath__er
blathers134713792blather_s
blattered12198562blattered
blethered15165432blethered
blithered15156122blithered
clatterer11186982clatterer
flatterer12187672flatterer
gatherer12147902_gatherer
lathered121512322_lathered
latherers12158852_latherers
slathered13148542slathered
adherer1137573__adherer
alterer72713993al_t_erer
banterer102811773b_anterer
barterer102711633b_arterer
bather115322513b_ath__er
bathers124720363b_ather_s
battener10369393b_attener
battered113315053b_attered
batterers113110713b_atterers
bitterer10309773b_itterer
blabbered13184593blabbered
blackener1754973blackener
blasphemer1951993blasphemer
blathering16107583blathering
blatter94415653blat__ter
blatters104414093blatter_s
blazered2035063bla_zered
blether12459913bleth__er
blethers13429613blether_s
blither124812173blith__er
blithers134711233blither_s
blubberer12173453blubberer
blunderer1244543blunderer
blusterer11176293blusterer
bolsterer1145483bolst_erer
bothered142110393b_othered
brothered1546003brothered
butcherer1643753butcherer
caterer92815943_cat_erer
catheter1338153_catheter
chatterer14196843chatterer
clamberer15185273clamberer
clattered12178403clattered
clatterers12155423clatterers
ditherer12187763_ditherer
falterer11239853falt_erer
fathered151510433_fathered
feathered16188893feathered
featherier1645803featherier
flattener12175173flattener
flattered13188623flattered
flatterers13175913flatterers
flutterer12185263flutterer
furtherer1543813furtherer
gathered13149373_gathered
gatherers13156883_gatherers
heathered16149463heathered
lateener835763_lateener
lather95124353_lath__er
lathers104321883_lather_s
lathery133911123_lather_y
lathier10310833_lath_ier
leathered13148713leathered
letterer8259223_letterer
litterer82810173_litterer
palterer102411273palt_erer
patterer103112173_patterer
plasterer1178103plasterer
scatterer11186293scatterer
shatterer12177203shatterer
slanderer1046673slanderer
slather103816073slath__er
slathers113914783slather_s
slaverer11196993sla_verer
slithered13136623slithered
smatterer11185813smatterer
smotherer1444633smotherer
waterer103314073_wat_erer
weathered16168513weathered
witherer14187953_witherer

Search took 9 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 Limit148641867.81319024.8
3Display Results86860.0332606.1
 (SQL Overall)178691868.00222330.8
 
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.