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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

141 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
troubling123494(None) 
doubling1238152_doubling
tousling938792t_ousling
touzling1835502t_ouzling
trebling1139872tr_ebling
trembling1435192trembling
trolling93212492tro_lling
trouncing1235152trouncing
trouping11249502trou_ping
troweling1376362troweling
arousing93811803arou_sing
bobbling12238643_bobbling
brabbling1334963brabbling
brambling1635543brambling
broiling113112013bro_iling
cobbling15248803_cobbling
coupling13310783_coupling
crouching1746383crouching
crumbling1655083crumbling
doubting1237373_doubting
drabbling1544553drabbling
dribbling1533713dribbling
drolling103510763dro_lling
drooling102610423dro_oling
drouking1436443drou_king
drubbing14286053dr_ubbing
drumbling1544033drumbling
fouling113315373_fou_ling
fribbling1733673fribbling
frouncing1534763frouncing
gobbling14257533_gobbling
grabbling1564583grabbling
grouching1644943grouching
grounding1236083grounding
groundling1343393groundling
grouping12308533grou_ping
grousing103410453grou_sing
grouting103410793grou_ting
groveling1435573groveling
growling1348163gro_wling
grubbing14295403gr_ubbing
grueling1078273gr_ueling
grumbling1544083grumbling
hobbling16227583_hobbling
nobbling13228273_nobbling
probing123314443pro_b_ing
profiling1548233profiling
prowling1449993pro_wling
rabbling13239333_rabbling
rambling131810773_rambling
redoubling1443433redoubling
robbing123313213_ro_bbing
robing93618003_ro_b_ing
rockling15259383_rockling
roiling83220453_ro_iling
rolling83620413_ro_lling
rootling9269953_rootling
roughing13278343_roughing
rouging93114703_rou_ging
rounding102812283_rounding
rouping103715793_rou_ping
rousing83920553_rou_sing
rousting93913273_rousting
routing83821093_rou_ting
roweling122811123_roweling
rubbing123412273_r_ubbing
rubbling13238073_rubbling
rubying13297933_r_ubying
ruling73219553_r_u_ling
rumbling131910103_rumbling
strolling10238793stro_lling
strouding1136373strou_ding
tabling103216033t__abling
tholing112812333tho__ling
thouing11258603thou__ing
throbbing1743533thro_bbing
throttling1442793throttling
toddling11187003t_oddling
toggling11206483t_oggling
toiling83219023t_o_iling
toling73926123t_o__ling
tolling83418563t_o_lling
tombing123310533t_omb_ing
tooling82918313t_o_oling
tootling9279523t_ootling
toppling13197353t_oppling
totaling9610303t_otaling
touching143211343t_ouching
toughing13278553t_oughing
touring82915193t_ou_ring
tousing82916993t_ou_sing
touting84118453t_ou_ting
toweling122910373t_oweling
trachling1537823trachling
trailing92916093tr_ailing
trameling1249053trameling
trampling1436973trampling
trauchling1643473trauchling
traveling1349053traveling
trawling122710783tr_awling
treadling1137503treadling
treddling1234423treddling
trickling1647723trickling
trifling122411503tr_ifling
trilling92815963tr_illing
trindling1137133trindling
tripling112712553tr_ipling
troaking133310973tro_aking
trocking153612423tro_cking
troking123514103tro__king
trollings10286693tro_llings
trollying1354053trollying
tromping13319603tro_mping
trooping112710283tro_oping
trophying1844713trophying
trothing122410843tro_thing
trotline8310023tro_tline
trotting92510913tro_tting
trouble957713troubl__e
troubled1134983troubl_ed
troubler1035293troubl_er
troublers1135003troublers
troubles1057203troubl_es
troublous1143963troublous
trowelling1484913trowelling
trowing113413703tro__wing
trucing103211843tr_u_cing
trucking153310163tr_ucking
truckling1645073truckling
trudging11266443tr_udging
trueing83410183tr_u_eing
truing73913933tr_u__ing
trumping13308733tr_umping
trundling1135003trundling
trussing9268653tr_ussing
trusting93411653tr_usting
tubbing123510093t__ubbing
tubing93813093t__ub_ing
tumbling13219293t_umbling
undoubling14133433undoubling
wobbling16246923_wobbling

Search took 9 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.453394461.4
2DLD Change Limit1486411417.64019455.6
3Display Results1411410.0632238.1
 (SQL Overall)1786911418.15621909.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.