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

62 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
blatherers1517534(None) 
blatherer14176711blatherer_
latherers12158851_latherers
batterers113110712b_atterers
blathered15168352blathere_d
blathers134713792blath__ers
clatterers12155422clatterers
flatterers13175912flatterers
gatherers13156882_gatherers
latherer111310442_latherer_
adherers1296913__adherers
alterers82512493al_t_erers
banterers112410003b_anterers
barterers11269633b_arterers
bathers124720363b_ath__ers
batteners11238163b_atteners
batterer102713213b_atterer_
blackeners1844123blackeners
blasphemers2051713blasphemers
blather125314203blath__er_
blathering16107583blathering
blattered12198563blattere_d
blatters104414093blat__ters
blethered15165433blethere_d
blethers13429613bleth__ers
blithered15156123blithere_d
blithers134711233blith__ers
blubberers13162843blubberers
blunderers1343943blunderers
blusterers12174993blusterers
bolsterers1244683bolst_erers
butcherers1742703butcherers
caterers102814403_cat_erers
catheters1437013_catheters
chatterers15205463chatterers
clamberers16174113clamberers
clatterer11186983clatterer_
ditherers13196683_ditherers
falterers12238033falt_erers
flatteners13164153flatteners
flatterer12187673flatterer_
flutterers13184593flutterers
furtherers1643323furtherers
gatherer12147903_gatherer_
lateeners945563_lateeners
lathered121512323_lathere_d
lathers104321883_lath__ers
letterers9228113_letterers
litterers9228193_litterers
palterers11249533palt_erers
patterers112410123_patterers
plasterers1286123plasterers
scatterers12205043scatterers
shatterers13185723shatterers
slanderers1145143slanderers
slathered13148543slathere_d
slathers113914783slath__ers
slaverers12165993sla_verers
smatterers12174873smatterers
smotherers1543813smotherers
waterers112312783_wat_erers
witherers15146843_witherers

Search took 10 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 Filter1786911406030.1561145455.1
2DLD Change Limit140603629.00015622.6
3Display Results62620.063984.1
 (SQL Overall)178691629.21919382.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.