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

69 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
besteading144603(None) 
beheading1636162be_heading
besmearing1544322besmearing
bespeaking1944392bespeaking
bespreading1743502bespreading
bestriding1446002bestriding
bestudding1542652bestudding
steading103613592__steading
bartending1444913bartending
bastinading1573553bastinading
beading113221863b___eading
befleaing1544023beflea_ing
beleaping1436743be_leaping
bemeaning1436193be_meaning
bereaving1537573be_reaving
beseeching1843363beseeching
beseeming1435143bes_eeming
besetting12268423bes_etting
beshaming1735673bes_haming
besieging1344763besie_ging
bestead10389123bestead___
besteaded1345073bestead_ed
besteads11307123bestead__s
besting104923923best___ing
bestirring1343993bestirring
bestowing1535803best_owing
bestrewing1643773bestrewing
bestrowing1644373bestrowing
betaking153010153be_t_aking
betiding1239913be_t_iding
betraying1537713be_traying
bettering122212753bette_ring
breading123515463b__reading
deleading1237773de_leading
descending1546113descending
distending1348333distending
estating92614993_est_ating
esteeming1244703_esteeming
estraying1338293_estraying
estreating11710363_estreating
extending1835853_extending
festering132413173feste_ring
gestating11229983gest_ating
homesteading1962273homesteading
mastheading1843583mastheading
misleading1446833misleading
misreading1448263misreading
mistending1447953mistending
pestering122315663peste_ring
repleading1436623repleading
rereading111212713re_reading
resealing102115673res_ealing
reseating102421533res_eating
reseeding112410493res_eeding
resending112313363res_ending
respading1338803res_pading
respeaking1736803respeaking
respreading1545173respreading
restaging112410853rest_aging
restating102319413rest_ating
reteaming122110443re_teaming
retearing102214253re_tearing
retreading12128483retreading
steadings11307083__steadings
steadying14154503__steadying
stealing93416603__stealing
steaming114013213__steaming
unsteadying1641793unsteadying
westering132112643weste_ring

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 Filter1786911406030.406440125.6
2DLD Change Limit140603696.64021175.2
3Display Results69690.0302300.0
 (SQL Overall)178691697.07625253.1
 
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.