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

81 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
steamered124491(None) 
sneakered1443712sneakered
stamened1137632st_amened
stammered1444642stammered
steamed103712142steam__ed
steamer93313092steamer__
steamers103410872steamer_s
steered83615252ste__ered
beavered1437503_beavered
metamere1257353metamere_
metameres1347453metameres
sabered103213023s__abered
scampered1635233s_campered
sceptered1444723sceptered
seamed94823883s_eam__ed
seamer84223613s_eamer__
seamers94719433s_eamer_s
seared75232843s_ea__red
seaweed11108813s_eawe_ed
severed113513863s_e_vered
sewered112911243s_e_wered
sheared114516003shea__red
sheered113515453she__ered
sheltered1335573sheltered
shimmered1744783shimmered
simmered1336863s_immered
skeltered1443873skeltered
skewered1634213ske_wered
slavered12188033s_lavered
smeared104510623smea__red
sneered83113973sne__ered
speared104314423spea__red
speered103614813spe__ered
staggered1244473staggered
stammerer1344063stammerer
stamped124812813st_am_ped
stampeded15343923st_ampeded
stared75429873st_a__red
starred85013453st_a_rred
steaded92811673stea__ded
steadied1036563stea_died
stealer72913983stealer__
stealers83412213stealer_s
steamering1345443steamering
steamier1048303steam_ier
steeked124010473ste__eked
steeled83513223ste__eled
steeped103412283ste__eped
steepened1244073steepened
steerer73113633ste__erer
steeved113610133ste__eved
stemmed12278153ste_m_med
stemmer113210183stemmer__
stemmeries1445173stemmeries
stemmers12378443stemmer_s
stemmery15334693stemmer_y
stereoed937883ste_reoed
stoppered1444473stoppered
strangered1245413strangered
streambed1483333stream_bed
streamed11258903stream__ed
streamer10239513streamer__
streamers11228073streamer_s
stuttered10145763stuttered
summered1338143s_ummered
sweltered1344453sweltered
tabered103311593_t_abered
tampered13279463_t_ampered
tapered102612933_t_apered
teamed95418593_team__ed
teared75722153_tea__red
teaseled9186803_teaseled
teazeled18194233_teazeled
teddered11255183_teddered
teetered9258303_teetered
telfered1234883_telfered
tempered13248223_tempered
tendered102510603_tendered
tentered96412103_tentered
tethered1238493_tethered
trameled11309073_trameled

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.420425454.8
2DLD Change Limit148641817.22020587.4
3Display Results81810.0461760.9
 (SQL Overall)178691817.68623248.9
 
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.