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

54 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
blubberer1217345(None) 
blubbered13164111blubbered
blubberers13162841blubberers
blabbered13184592blabbered
blubber10399292blubb__er
blubbers11408142blubber_s
blubbery14294782blubber_y
blunderer1244542blunderer
blusterer11176292blusterer
lumberer12177582_lumberer
slobberer13153442slobberer
slubbered14175252slubbered
slumberer13194802slumberer
blabber10418923blabb__er
blabbers11308153blabber_s
blatherer14176713blatherer
blubbed11338393blubb__ed
blubbering14103443blubbering
blueberry1642773blueberry
blundered1335193blundered
blunderers1343943blunderers
blustered12157263blustered
blusterers12174993blusterers
boulderer1244403boulderer
bubbler103611783b_ubb_ler
bubblier1184473b_ubblier
clabbered16184753clabbered
clamberer15185263clamberer
clobbered16164103clobbered
clubber13319593clubb__er
clubbers14378573clubber_s
clubbier1434833clubb_ier
cumberer14266993_cumberer
flubber14287713flubb__er
flubbers15346893flubber_s
flutterer12185263flutterer
jabberer1944023_jabberer
limberer12187053_limberer
lubber104214623_lubb__er
lubberly1543663_lubberly
lubbers113913723_lubber_s
lumbered13188233_lumbered
lumberers13196013_lumberers
numberer12186313_numberer
plunderer1243743plunderer
rubbered1335383_rubbered
rubberier1344393_rubberier
slabbered14165083slabbered
slobbered14144223slobbered
slobberers14152883slobberers
slubber113010763slubb__er
slubbers12349943slubber_s
slumbered14215593slumbered
slumberers14203683slumberers

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 Limit148641547.03021143.8
3Display Results54540.0301800.0
 (SQL Overall)178691547.21624763.2
 
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.