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

451 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
trancing11281202(None) 
prancing132612161prancing
tracing103720151tra_cing
bracing123817612bra_cing
branching17289262branching
branding122513682branding
branning112911092branning
chancing162810282chancing
cranching17278732cranching
craning103620302cran_ing
cranking154613072cranking
dancing113611562_dancing
entrancing1346782entrancing
franking164310862franking
glancing1247062glancing
gracing113216442gra_cing
granting103514522granting
lancing103314122_lancing
pranging123012722pranging
pranking153813382pranking
racing95030532_ra_cing
ranching141712042_ranching
ranging94120262_ranging
ranking124320882_ranking
ranting84025412_ranting
stranding1149652stranding
talcing103111632t_alcing
tanging93419522t_anging
tanking123918792t_anking
tanning83618252t_anning
thanking16409522thanking
tracings112910402tra_cings
tracking153715462tracking
trading93517972tra_ding
traducing1374012traducing
traiking132511972traiking
trailing92916092trailing
training93015862training
tramming13279342tramming
tramping132711272tramping
trapping132911392trapping
trashing122613222trashing
trawling122710782trawling
trenching15227652trenching
trending103012832trending
tricing103417352tr_icing
trining82919212trin_ing
trouncing1235152trouncing
truanting1035602truanting
trucing103211842tr_ucing
twanging13287062twanging
acing87429153__a_cing
advancing1643063advancing
anting75827023__anting
arcing95819643__arcing
arranging1156303arranging
balancing1435783balancing
banding114921413_banding
banging114019863_banging
baning95127833_ban_ing
banking144621353_banking
banning103818233_banning
barning104320353barn_ing
beaning103820683bean_ing
blanching17297093blanching
blanking154411933blanking
bouncing13318773bouncing
bracings13369283bra_cings
bradding13268933bradding
bragging13359333bragging
braiding123112703braiding
brailing113514793brailing
braining113414683braining
braising113014563braising
braking143917703bra_king
brandings13277483brandings
brandling1348253brandling
brandying1654883brandying
brassing112612303brassing
braving133714613bra_ving
bravoing1445993bravoing
brawling143210043brawling
braying134416313bra_ying
brazing193715113bra_zing
bringing123011273bringing
brining103216473brin_ing
bronzing2037693bronzing
brunching17316483brunching
caning94128623_can_ing
canning103620133_canning
canting104725903_canting
changing153211513changing
chanting143413533chanting
clanging124012123clanging
clanking154313063clanking
craaling112711353craaling
crabbing15287933crabbing
cracking174013903cracking
cradling122411453cradling
crafting143710173crafting
cramming15339433cramming
cramping153411853cramping
crankling16147293crankling
craping124018713cra_ping
crapping153911453crapping
crashing143512633crashing
crating103725203cra_ting
craunching1843313craunching
craving134015733cra_ving
crawling143110513crawling
crazing193914583cra_zing
cringing123311383cringing
crunching17297003crunching
danging103716093_danging
darning93817333darn_ing
deaning94020473dean_ing
deranging1238063deranging
drabbing14286803drabbing
drafting13339403drafting
dragging12308103dragging
draining103312673draining
dramming14347563dramming
draping114213353dra_ping
dratting10389653dratting
drawing123812053dra_wing
drawling13318673drawling
draying123813843dra_ying
drenching16256033drenching
drinking14308913drinking
droning93013723dron_ing
eanling81416673_eanling
earning83418213earn_ing
enhancing1545823enhancing
erasing8317953era_sing
estranging1246023estranging
evincing1446183evincing
facing125321573_fa_cing
fancying1735353_fancying
fanning113615073_fanning
farcing133514003_farcing
fencing132411133_fencing
financing1544073financing
flanging132710583flanging
flanking164211083flanking
fragging14329423fragging
framing133014793fra_ming
francium1545623francium
francize2246853francize
francizing2545373francizing
frapping16348103frapping
fraying143413433fra_ying
frenching18267753frenching
fringing133010903fringing
fronting12310443fronting
frouncing1534763frouncing
furnacing1543713furnacing
ganging103216193_ganging
grabbing14267313grabbing
grading103918713gra_ding
grafting13319623grafting
graining102813183graining
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
grating93923183gra_ting
graving123114563gra_ving
graying124115883gra_ying
grayling1338003grayling
grazing183514553gra_zing
grinding1139863grinding
grinning1037863grinning
groaning102410283groan_ing
grunting10269583grunting
handing123518893_handing
hanging123518703_hanging
hanking154619103_hanking
hanting114124483_hanting
ironing82414013iron_ing
jauncing18314783jauncing
jouncing18336853jouncing
kraaling13186663kraaling
lacing94626233_la_cing
landing92819323_landing
leaning83721203lean_ing
loaning83614833loan_ing
macing114221553_ma_cing
manning103616383_manning
meaning103918693mean_ing
menacing1339773menacing
mincing123314333_mincing
moaning103714443moan_ing
orating83520323ora_ting
outdancing1445223outdancing
outracing12912163outra_cing
outranging1238003outranging
outranking1537673outranking
pacing114522753_pa_cing
panging113319113_panging
panning104019393_panning
panting104025423_panting
peacing124117073pea_cing
penancing1436343penancing
placing123815283pla_cing
planing103418253plan_ing
planking153513013planking
planning113610223planning
planting113515383planting
poncing122913583_poncing
pouncing13318883pouncing
praising113214563praising
prating103424453pra_ting
prawning1446963prawning
praying133717323pra_ying
pricing123417343pr_icing
prinking153212453prinking
printing113216083printing
pronging123511843pronging
pruning10311733prun_ing
quanting1849233quanting
racings105015123_ra_cings
racking144323663_racking
radding103715003_radding
rafting113815753_rafting
ragging103516683_ragging
raging85126433_ra_ging
raiding93617593_raiding
railing83325643_railing
raining83922693_raining
raising83220533_raising
raking114728413_ra_king
ramming123115063_ramming
ramping123316873_ramping
rancid9513863_ranci_d
rankings13389163_rankings
rankling132610113_rankling
raping94829853_ra_ping
rapping123619103_rapping
raring74332873_ra_ring
rasing74330833_ra_sing
rasping104316253_rasping
rating74938703_ra_ting
ratting83822363_ratting
raving105128853_ra_ving
raxing144321023_ra_xing
raying105027193_ra_ying
razing164524543_ra_zing
razzing1636323_razzing
rending93924263_rending
renting84026853_renting
retracing12313283retra_cing
ricing94822763_r_icing
ringing93521283_ringing
rinning83216743_rinning
rinsing82516113_rinsing
romancing1446043romancing
running83514593_running
sanding93520603_sanding
saning75127643_san_ing
saucing10311003_saucing
scanning113310773scanning
scanting113914763scanting
sconcing1338263sconcing
shanking163612283shanking
skanking12288743skanking
slanging103413433slanging
slanting94115093slanting
spacing123614493spa_cing
spanking153911973spanking
spanning113311083spanning
stanching1538083stanching
standing103413633standing
stanging104013653stanging
staning83922243stan_ing
strafing122111193stra_fing
straining10410563straining
strangling1256403strangling
strapping1436993strapping
strawing122411623stra_wing
straying122912693stra_ying
stringing1139753stringing
strunting1037873strunting
swanking16399963swanking
swanning12338813swanning
syncing13177223_syncing
tabbing123611913t_abbing
tabling103216033t_abling
tabuing10308893t_abuing
tacking144421483t_acking
tagging103014913t_agging
tailing82923103t_ailing
tainting93613583tainting
taking114725953t_a_king
talcking1567083t_alcking
talking123815823t_alking
taming94023433t_a_ming
tamping122815813t_amping
tangling101712533t_angling
tangoing10177893t_angoing
tankini11338923t_ankini
tannin62613923t_annin_
tannings9268633t_annings
tannins72813223t_annins
taping94222393t_a_ping
tapping123317133t_apping
taring73932283t_a_ring
tarring83318303t_arring
tarrying12146713tarrying
tarting84222653t_arting
tasking124616323t_asking
tasting84624213t_asting
tatting84019523t_atting
taunting93510933taunting
tauting83316383t_auting
tawing104521553t_a_wing
tawsing1138673t_awsing
taxiing1535723t_axiing
taxing143816713t_a_xing
taxying1836183t_axying
teaching143612603teaching
teaming103917593tea_ming
tearing84021493tea_ring
teasing83918513tea_sing
teazling1856573teazling
tenanting1036213tenanting
tending94419163t_ending
tensing84616653t_ensing
tenting84621153t_enting
terracing1237683terracing
thacking183110043thacking
thatching1835143thatching
thawing14378683tha_wing
thinking16289843thinking
thinning12319073thinning
thralling13256833thralling
thrashing1635673thrashing
thrawing1535963thra_wing
thronging1435073thronging
throning1238863thron_ing
thunking16196953thunking
ticcing12308633t_iccing
tincting1148883t_incting
tinging93619443t_inging
tining74927543t_in_ing
tinning83117283t_inning
tinting84620603t_inting
toadying1335043toadying
toasting93410573toasting
tonging93314513t_onging
toning74025793t_on_ing
trachling1537823trachling
trackings16247533trackings
train56529113tra__in_
trainings10246723trainings
trains64725343tra__ins
traipsing1235063traipsing
trajecting2044293trajecting
trameling1249053trameling
tramline10311383tramline
trampling1436963trampling
trance84718763tranc__e
tranced104414173tranc_ed
trances93919643tranc_es
tranche123312223tranc_he
tranches132915513tranches
trannies8415013trannies
tranny94210863tran__ny
transacting1446513transacting
transcend1246443transcend
transducing1554343transducing
transecting1447363transecting
transient9713213transient
transit7317163transi_t
transiting11410763transiting
transits8313493transits
transuding1245993transuding
trapanning1343213trapanning
trapesing1247263trapesing
trapline10411863trapline
trappings14265753trappings
trauchling1643473trauchling
traveling1349053traveling
treading103515333treading
treadling1137503treadling
treating92519613treating
trebling1139873trebling
treeing83414303tr_eeing
trekking1235543trekking
trepanning1344153trepanning
triaging102610543triaging
tricking152714513tricking
trifling122411503trifling
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trindling1137133trindling
tripling112712553tripling
tripping133210923tripping
trithing122811773trithing
troaking133310963troaking
trocking153612423trocking
troking123514103tr_oking
trolling93212493trolling
tromping13319593tromping
trooping112710273trooping
trothing122410843trothing
trotting92510913trotting
trouping11249503trouping
trowing113413703tr_owing
truancies1146873truancies
trucking153310163trucking
trudging11266443trudging
trueing83410183tr_ueing
truing73913933tr__uing
trumping13308733trumping
truncating1344223truncating
trundling1135003trundling
trussing9268653trussing
trusting93411653trusting
trying104214073tr__ying
trysting12267053trysting
tuning74016843t_un_ing
tunning83514453t_unning
turning83713183turn_ing
twangling1434453twangling
twinging13278403twinging
twining113211443twin_ing
twinning12367043twinning
tyning105510413t_yn_ing
valancing1544743valancing
vanning113912463_vanning
waning103623803_wan_ing
wanking154216783_wanking
wanning113816213_wanning
wanting114220173_wanting
warning113717093warn_ing
weaning114117193wean_ing
weanling12118643weanling
whanging16267143whanging
wincing133413903_wincing
wracking18349963wracking
wrangling1456223wrangling
wrapping16297623wrapping
wrathing15248923wrathing
wrenching18276273wrenching
wringing13279623wringing
wronging13327393wronging
yanking154512463_yanking
yarning113512953yarn_ing
yeaning113814633yean_ing
yeanling12107063yeanling
zincing192910283_zincing

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461624517.96618348.2
3Display Results4514510.1902373.7
 (SQL Overall)1786914518.32921454.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.