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 “troaking” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

47 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
troaking13331097(None) 
croaking153712161croaking
trocking153612421trocking
troking123514101tro_king
braking143917712br_aking
breaking153914252breaking
broking143514822bro_king
brooking153710702brooking
cloaking15299712cloaking
creaking153414122creaking
crocking174313442crocking
crooking153611342crooking
drouking1436442drouking
freaking163611452freaking
frocking18309572frocking
groaning102410282groaning
grokking1334812grokking
raking114728422_r_aking
roaming103215792_roaming
roaring82916002_roaring
rocking143619632_rocking
rooking123517362_rooking
soaking123116612_soaking
streaking142010322streaking
stroking132610942stro_king
taking114725952t__aking
throating1398402throating
toking114420722t_o_king
tracing103720152tr_acing
tracking153715462tracking
trading93517972tr_ading
traiking132511972traiking
treading103515332treading
treating92519612treating
trekking1235542trekking
triaging102610542triaging
tricking152714512tricking
trolling93212492trolling
tromping13319602tromping
trooping112710282trooping
trothing122410842trothing
trotting92510912trotting
trouping11249502trouping
trowing113413702tro_wing
trucking153310162trucking
tweaking1635882tweaking
wreaking163010212wreaking

Search took 5 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 Filter1786911210590.373479064.3
2DLD Change Limit121059474.01630144.2
3Display Results47470.0162937.5
 (SQL Overall)178691474.40540565.5
 
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.