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

170 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
trachling153782(None) 
trauchling1643471trauchling
crackling18157002crackling
tackling153211122t_ackling
teaching143612602teach_ing
tracing103720152trac__ing
tracking153715462trac_king
trailing92916092tra_iling
trameling1249052trameling
trampling1436962trampling
trashing122613222trash_ing
traveling1349052traveling
trawling122710782tra_wling
trickling1647722trickling
truckling1645072truckling
aching126521973__ach_ing
arching136216693ar_ch_ing
attaching1545433attach_ing
baching156017753_bach_ing
beaching164114143beach_ing
brabbling1334963brabbling
bracing123817613brac__ing
brailing113514793bra_iling
brailling1247773brailling
brambling1635543brambling
branching17289263branch_ing
branchline1744123branchline
brandling1348253brandling
brattling1236003brattling
brawling143210043bra_wling
breaching17269403breach_ing
broaching17287663broach_ing
caching156317503_cach_ing
cackling172610943_cackling
caracoling1545633caracoling
coaching164011963coach_ing
craaling112711353cra_aling
cracking174013903crac_king
cracklings19143523cracklings
cradling122411453cra_dling
cranching17278733cranch_ing
crankling16147293crankling
crashing143512633crash_ing
crawling143110513cra_wling
drabbling1544553drabbling
draggling1354613draggling
drawling13318673dra_wling
earthling1346193earthling
frazzling2143153frazzling
freckling1934703freckling
grabbling1564583grabbling
gracing113216443grac__ing
graphing1538533graph_ing
grappling1544993grappling
graveling1457383graveling
grayling1338003gra_yling
hackling183310163_hackling
hatchling1844953hatchling
kraaling13186663kra_aling
leaching143012833leach_ing
mackling172710063_mackling
maculing13219583_maculing
marching164312193march_ing
parceling1438443parceling
parching164313053parch_ing
peaching163613643peach_ing
poaching163510833poach_ing
prattling1246303prattling
preaching172811163preach_ing
prickling1836533prickling
rabbling13239333_rabbling
racheting1537793_racheting
racing95030533_rac__ing
racking144323663_rac_king
raddling11229773_raddling
raffling1567063_raffling
railing83325643_ra_iling
rambling131810773_rambling
ranching141712043_ranch_ing
rankling132610113_rankling
rassling939013_rassling
rattling92510873_rattling
raveling123414373_raveling
reaching143317203reach_ing
roaching143210433roach_ing
rockling15259383_rockling
ruching133612933_ruch_ing
ruckling15258573_ruckling
shackling19286173shackling
spackling18266503spackling
starching1538593starch_ing
straddling1343643straddling
straggling1344303straggling
strangling1256403strangling
strickling1744953strickling
tabling103216033t_a_bling
tacking144421483t_ac_king
tacklings16235853t_acklings
tailing82923103t_a_iling
tangling101712543t_angling
tattling9259473t_attling
teachings15296553teach_ings
teaseling1036913teaseling
teazeling1934543teazeling
teazling1856573tea_zling
thacking183110043thac_king
thatching1835143thatch_ing
thralling13256833thra_lling
thrashing1635673thrash_ing
tickling15309433t_ickling
torching142510083torch_ing
touching143211343touch_ing
touchline1444473touchline
tracheid1437583trachei_d
tracheids1545053tracheids
trachle12311853trachl__e
trachled1438313trachl_ed
trachles13311753trachl_es
tracings112910413trac__ings
trackings16247543trac_kings
tracklaying2152393tracklaying
trading93517973tra__ding
traducing1374013traducing
traiking132511973tra_iking
training93015863tra_ining
traipsing1235073traipsing
tramelling1346373tramelling
tramline10311383tra_mline
trammeling1544023trammeling
tramming13279343tra_mming
tramping132711273tra_mping
trancing112812023tra_ncing
trapesing1247263trapesing
trapline10411863tra_pline
trapping132911393tra_pping
travailing1444613travailing
travelling1456533travelling
treadling1137503treadling
trebling1139873tr_ebling
treddling1234423treddling
trembling1435183trembling
trenching15227653trench_ing
trichina1348093trich_ina
tricing103417353tric__ing
tricking152714513tric_king
trifling122411503tr_ifling
trilling92815963tr_illing
trindling1137133trindling
tripling112712553tr_ipling
trithing122811773trith_ing
trocking153612423troc_king
trolling93212493tr_olling
trophying1844713trophying
trothing122410843troth_ing
troubling1234933troubling
troweling1376363troweling
trucing103211843truc__ing
trucking153310163truc_king
truckline1544913truckline
trundling1135003trundling
twaddling1552713twaddling
twangling1434453twangling
twattling1332693twattling
vetchling1843593vetchling
wracking18349963wrac_king
wrangling1456223wrangling
wrassling1334273wrassling
wrastling1335523wrastling
wrathing15248923wrath_ing
yachting1734933_yachting

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.1701051123.5
2DLD Change Limit1486411707.11020905.9
3Display Results1701700.0802125.0
 (SQL Overall)1786911707.36024278.7
 
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.