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

201 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
trickling164772(None) 
prickling1836531prickling
strickling1744951strickling
tickling15309431t_ickling
tricking152714511trick_ing
truckling1645071truckling
bricking173911402brick_ing
crackling18157002crackling
cricking173412652crick_ing
crinkling16145862crinkling
freckling1934702freckling
nickling15278702_nickling
pickling17239202_pickling
pricking173212602prick_ing
ricking143920232_rick_ing
rockling15259382_rockling
ruckling15258572_ruckling
sickling152910332_sickling
stickling1647002stickling
tackling153211122t_ackling
ticking143218752t_ick_ing
tinkling13239232t_inkling
trachling1537822trachling
tracking153715462track_ing
tricing103417352tric__ing
tricklier15256822tricklier
trifling122411502tri_fling
trilling92815962tri_lling
trindling1137132trindling
tripling112712552tri_pling
trocking153612422trock_ing
trucking153310162truck_ing
truckline1544912truckline
twinkling1743642twinkling
wricking18349492wrick_ing
wrinkling17144952wrinkling
arcking145811963ar_ck_ing
articling1247713artic_ling
bricklaying2351833bricklaying
bricklike1643113bricklike
bridling122610583bri_dling
brisking15329473brisk_ing
brisling112410843bri_sling
bristling1246663bristling
brittling1235543brittling
buckling17259113_buckling
cackling172610943_cackling
chuckling2144193chuckling
circling1338423circ_ling
clicking173610983click_ing
cockling172310393_cockling
cracking174013903crack_ing
cracklings19143523cracklings
crankling16147293crankling
cricketing1944033cricketing
crimpling1645343crimpling
crippling1644093crippling
crocking174313443crock_ing
dicking153617613_dick_ing
dribbling1533713dribbling
drilling103311983dri_lling
drinking14308913drink_ing
driveling1445763driveling
drizzling1943023drizzling
duckling16247703_duckling
flicking184110043flick_ing
fribbling1733673fribbling
frilling123011493fri_lling
frisking16268363frisk_ing
frivoling1644493frivoling
frizzling2153113frizzling
frocking18309573frock_ing
griddling1333933griddling
grilling103811533gri_lling
grizzling1942843grizzling
hackling183310163_hackling
heckling18257163_heckling
hoicking1836053hoick_ing
inkling122911303__inkling
keckling14245523_keckling
kicking133314023_kick_ing
knuckling1542753knuckling
licking144118283_lick_ing
mackling172710063_mackling
nickeling1645393_nickeling
nicking143516323_nick_ing
picking163418333_pick_ing
pricing123417343pric__ing
prickings18315653prick_ings
pricklier17245063pricklier
prilling113413413pri_lling
princeling1544653princeling
prinking153212453prink_ing
racking144323663_rack_ing
rankling132610113_rankling
recking144319923_reck_ing
ricing94822763_ric__ing
riddling11249443_riddling
ridgling11258203_ridgling
riesling939013_riesling
riffling1556113_riffling
rifling112815013_ri_fling
riling74227973_ri__ling
rilling84023623_ri_lling
rimpling13219663_rimpling
rippling13197573_rippling
risking123914243_risk_ing
rivaling1239913_rivaling
rocking143619633_rock_ing
rocklings16224843_rocklings
rucking143216673_ruck_ing
runkling13217613_runkling
shackling19286173shackling
sicking143720173_sick_ing
sicklying1943883_sicklying
slicking153712593slick_ing
snicking153610233snick_ing
spackling18266503spackling
speckling18235583speckling
sprinkling1743823sprinkling
sticking153513463stick_ing
striking133012233stri_k_ing
stripling1257783stri_pling
suckling152410023_suckling
tacking144421483t_ack_ing
tacklings16235853t_acklings
tailing82923103tai__ling
talcking1567083talck_ing
thacking183110043thack_ing
thickening2043283thickening
thinking16289863think_ing
thirling12248583thi_rling
thrilling13276693thri_lling
ticcing12308633t_ic_cing
ticketing1635633t_icketing
tickings15368583t_ick_ings
ticklish1755283t_icklish
tiling73426553t_i__ling
tilling83522783t_i_lling
tingling102210823t_ingling
tinklings14224663t_inklings
tippling13196703t_ippling
tirling83315733t_i_rling
titling83715793t_i_tling
toiling83219023toi__ling
tracing103720153trac__ing
trackings16247543track_ings
tracklaying2152393tracklaying
traiking132511973traik_ing
trailing92916093tr_ailing
trameling1249053trameling
trampling1436973trampling
trauchling1643473trauchling
traveling1349053traveling
trawling122710783tr_awling
treadling1137503treadling
trebling1139873tr_ebling
treddling1234423treddling
trekking1235543tr_ekking
trembling1435193trembling
triaging102610543tri_aging
trichina1348093tric_hina
trickie132611033trick_i_e
trickier143010233trick_ier
trickily1736233trick_ily
trickish1746793trick_ish
trickle133613443trickl__e
trickled152610433trickl_ed
trickles143013763trickl_es
trickliest1646433trickliest
trickly16369893trickl__y
tricksier15275243tricksier
triclinia1154163tric_linia
triclinic1354223tric_linic
tricotine1148253tricotine
triflings13235973tri_flings
trigging11299583tri_gging
trimming13318653tri_mming
trining82919213tri__ning
trinketing1544153trinketing
tripping133210923tri_pping
trithing122811773tri_thing
troaking133310973troak_ing
troking123514103tr_ok_ing
trolling93212493tr_olling
troubling1234943troubling
troweling1376363troweling
trucing103211843truc__ing
truckings16235023truck_ings
trucklines1644293trucklines
trundling1135003trundling
tucking143415183t_uck_ing
twiddling1543083twiddling
twilling12268673twi_lling
twinklings1841883twinklings
twirling12246243twi_rling
wicking173414773_wick_ing
winkling16298293_winkling
wracking18349963wrack_ing
wrecking18328153wreck_ing
wriggling1533813wriggling

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412016.65322342.0
3Display Results2012010.0962093.8
 (SQL Overall)1786912017.17224915.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.