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

46 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
trauchling164347(None) 
trachling1537821tra_chling
truckling1645072tr_uckling
branching17289263branch_ing
branchline1744123branchline
crackling18157003cra_ckling
cranching17278733cranch_ing
craunching1843313craunch_ing
crouching1746383crouch_ing
draughting1642883draughting
fraughting1843063fraughting
grouching1644943grouch_ing
hatchling1844953_hatchling
ranching141712043_ranch_ing
ruching133612933_r_uch_ing
ruckling15258573_r_uckling
tackling153211123t_a_ckling
teaching143612603tea_ch_ing
thatching1835143thatch_ing
touching143211343t_ouch_ing
touchline1444473t_ouchline
tracing103720153tra_c__ing
tracking153715463tra_c_king
traducing1374013traduc__ing
trailing92916093tra__iling
trameling1249053tra_meling
tramelling1346373tramelling
trammeling1544023trammeling
trampling1436973tra_mpling
trancing112812023tranc__ing
trashing122613223tra_sh_ing
trauchle1344963trauchl__e
trauchled1543733trauchl_ed
trauchles1445493trauchl_es
travailing1444613travailing
traveling1349053tra_veling
travelling1456533travelling
trawling122710783tra__wling
trenching15227653trench_ing
trickling1647723tr_ickling
troubling1234943trou_bling
trucing103211843tr_uc__ing
trucking153310163tr_uc_king
truckline1544913tr_uckline
trundling1135003tr_undling
wauchting1843473_wauchting

Search took 7 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.436409841.7
2DLD Change Limit140603466.06323190.3
3Display Results46460.0162875.0
 (SQL Overall)178691466.51527427.6
 
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.