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

37 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
truckled1532731(None) 
ruckled144111031_ruckled
trickled152610431trickled
trucked143910811truck_ed
truckle13358861truckle_
truckler14297451truckler
truckles14319381truckles
buckled164411882_buckled
chuckled2045162chuckled
crackled17428862crackled
freckled18104442freckled
knuckled1463562knuckled
prickled17358072prickled
rucked134718762_ruck_ed
ruckle124414582_ruckle_
ruckles133414602_ruckles
runkled12399012_runkled
strickled1665832strickled
suckled144212512_suckled
tackled143913192t_ackled
tickled144313132t_ickled
trachled1438312trachled
tracked143716132track_ed
trauchled1543732trauchled
tricked144016162trick_ed
trickle133613442trickle_
trickles143013762trickles
trocked144312242trock_ed
truced95312052truc__ed
trucker134010732truck_er
trucklers15295582trucklers
truckload1641972truckload
truckmen1643372truckmen
truffled1563992truffled
trundled10306392trundled
trunked12358412trunk_ed
tucked134017492t_uck_ed

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.456391866.2
2DLD Change Limit121059373.76332170.9
3Display Results37370.0162312.5
 (SQL Overall)178691374.23542193.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.