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

67 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
spluttered1315317(None) 
splattered13163931splattered
splutterer12132741splutterer
sputtered12166321sp_uttered
cluttered12185932_cluttered
fluttered13185942_fluttered
puttered112611142_p_uttered
scuttered12166422s_cuttered
shuttered13156332s_huttered
spattered12187642sp_attered
splintered1383922splintered
splutter10357442splutter__
splutterers13142162splutterers
splutters11286262splutter_s
spluttery14293622splutter_y
sputterer11165262sp_utterer
stuttered10145762s_tuttered
blattered12198563_blattered
blustered12157263_blustered
buttered112712623__buttered
clattered12178403_clattered
clustered12186603_clustered
delustered1243293delustered
flattered13188623_flattered
flittered13196253_flittered
flustered13185883_flustered
flutterer12185263_flutterer
glittered11195403_glittered
guttered10259153__guttered
lettered92910783__lettered
littered92511383__littered
lustered92510603__lustered
muttered112610793__muttered
pattered112714203_p_attered
plastered1288893_plastered
plundered1344303_plundered
pottered112311663_p_ottered
putterer10209913_p_utterer
relettered1144333relettered
reuttered1036073_reuttered
sauntered1036283s_auntered
scattered12197353s_cattered
scouthered1643643scouthered
shattered13178203s_hattered
skittered1434633s_kittered
slathered13148533s_lathered
slithered13136623s_lithered
slubbered14175253s_lubbered
slumbered14215593s_lumbered
smattered12186783s_mattered
splatted11356743splatt__ed
splatter10348883splatter__
splatters11327543splatter_s
splitter10348443splitter__
splitters11307323splitter_s
spluttering1463363spluttering
sputter94014053sp_utter__
sputterers12174583sp_utterers
sputters104012863sp_utter_s
sputtery13366473sp_utter_y
squattered2043253squattered
stutterer9164913s_tutterer
unbuttered1353133unbuttered
uncluttered1451913uncluttered
unlettered1143953unlettered
unuttered1065733_unuttered
uttered82712433___uttered

Search took 6 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.1731032896.0
2DLD Change Limit140603675.73624512.4
3Display Results67670.0302233.3
 (SQL Overall)178691675.93930087.7
 
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.