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

520 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
training9301586(None) 
braining113414681braining
draining103312671draining
graining102813181graining
raining83922691_raining
straining10410561straining
traiking132511971traiking
trailing92916091trailing
trainings10246721trainings
trining82919211tr_ining
attaining1047222attaining
braiding123112702braiding
brailing113514792brailing
braising113014562braising
branning112911092branning
brining103216472br_ining
chaining142810782chaining
craning103620302cra_ning
detraining1267672detraining
entraining1147642entraining
gaining94015662_gaining
groining102310632groining
ordaining1145752ordaining
paining103920242_paining
plaining113911552plaining
praising113214562praising
prawning1446962prawning
raiding93617592_raiding
railing83325642_railing
raising83220532_raising
ravining12269692_ravining
reining84425322_reining
retraining11310242retraining
ruining83514882_ruining
saining83621392_saining
spraining1248152spraining
staining9413372staining
tailing82923102t_ailing
tainting93613582t_ainting
tanning83618252t_anning
tining74927542t__ining
tracing103720152tra_cing
tracking153715462tracking
trading93517972tra_ding
traipsing1235072traipsing
tramming13279342tramming
tramping132711272tramping
trancing112812022trancing
trapping132911392trapping
trashing122613222trashing
trawling122710782trawling
triaging102610542triaging
tricing103417352tr_icing
twining113211442t_wining
aiding84423613__aiding
ailing74331013__ailing
aiming94320843__aiming
airing74927503__airing
alining81917043_alining
arabizing2147963arabizing
arginine948563arginine
arising83619973ar_ising
arointing1049363arointing
arraigning1242783arraigning
arriving1237363arriving
attainting1144783attainting
availing1267283availing
awaiting1238273awaiting
awning105013393__awning
bailing103723523_bailing
baiting103918883_baiting
baning95127833_ba_ning
banning103818233_banning
bargaining1445213bargaining
barning104320353_barning
beaning103820683bea_ning
bracing123817613bra_cing
bradding13268933bradding
bragging13359333bragging
braidings13285903braidings
brailling1247773brailling
brainiac1245633brainiac
brainier102510233brainier
brainily1337313brainily
brainish1338813brainish
braking143917713bra_king
branding122513683branding
brassing112612303brassing
braving133714613bra_ving
bravoing1445993bravoing
brawling143210043brawling
braying134416313bra_ying
brazening2185183brazening
brazing193715113bra_zing
bribing123111043br_ibing
bringing123011273br_inging
broiling113112013broiling
browning14299643browning
bruising11279143bruising
bruiting11259973bruiting
bylining1446013bylining
cabining1338643cabining
caning94128623_ca_ning
canning103620133_canning
chairing143110773chairing
chining133316843_chining
claiming13279303claiming
coining103920543_coining
craaling112711353craaling
crabbing15287933crabbing
cracking174013903cracking
cradling122411453cradling
crafting143710173crafting
cramming15339433cramming
cramping153411853cramping
cranking154613073cranking
craping124018713cra_ping
crapping153911453crapping
crashing143512633crashing
crating103725203cra_ting
cravening1547553cravening
craving134015733cra_ving
crawling143110513crawling
crayoning1535243crayoning
crazing193914583cra_zing
cringing123311383cr_inging
crooning113112113crooning
crowning143510033crowning
cruising112610153cruising
curtaining1345533curtaining
damning114211633_damning
darning93817333_darning
dawning124111013_dawning
deairing10311893deairing
deaning94020473dea_ning
defining133711803defining
deraigning1344103deraigning
derailing112011313derailing
detaining112510473detaining
dining84525133__dining
distraining1346983distraining
divining1338413divining
drabbing14286803drabbing
drafting13339413drafting
dragging12308103dragging
dramming14347573dramming
draping114213353dra_ping
dratting10389663dratting
drawing123812053dra_wing
drawling13318673drawling
draying123813843dra_ying
drinking14308913dr_inking
driving123910713dr_iving
droning93013723dr_oning
drowning13298363drowning
dwining12269293_dwining
earning83418213_earning
eloining9310443eloining
emailing113010043emailing
engining1039293engining
engraining1245223engraining
erasing8317963era_sing
examining1945143examining
failing113521333_failing
fainting123312163_fainting
fairing113614013_fairing
fanning113615073_fanning
fawning14409133_fawning
fining104223213__fining
flailing12298923flailing
foining113013453_foining
fragging14329423fragging
framing133014793fra_ming
franking164310863franking
frapping16348103frapping
fraying143413433fra_ying
fringing133010903fr_inging
frizing203310873fr_izing
frowning15307833frowning
fruiting12229063fruiting
gaiting93716583_gaiting
glairing1047283glairing
grabbing14267313grabbing
gracing113216443gra_cing
grading103918713gra_ding
grafting13319623grafting
grainier9218903grainier
granting103514523granting
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
grating93923183gra_ting
graving123114563gra_ving
graying124115883gra_ying
grayling1338003grayling
grazing183514553gra_zing
greening103112533greening
griding103014973gr_iding
griming113612493gr_iming
grinding1139863gr_inding
grinning1037863grinning
griping113012063gr_iping
groaning102410283groaning
hailing113820693_hailing
imagining1345413imagining
ingraining1245623ingraining
irising83614423ir_ising
ironing82414013ir_oning
jailing153415843_jailing
joining153011483_joining
kraaling13186663kraaling
lairing83715343_lairing
leaning83721203lea_ning
learning978553learning
liaising937913liaising
lining74526803__lining
loaning83614833loa_ning
mailing102923343_mailing
maiming122912723_maiming
manning103616383_manning
margining1337603margining
meaning103918703mea_ning
mining94225453__mining
mistraining1446503mistraining
moaning103714443moa_ning
mutining11310493mutining
nailing83419963_nailing
obtaining1236773obtaining
opining10311743_opining
orating83520323ora_ting
orbiting1138153orbiting
outgaining1237093outgaining
outraising1139903outraising
paiking143814813_paiking
painting113614423_painting
pairing103716733_pairing
panning104019393_panning
patining11312303patining
pawning134711413_pawning
peining104619153_peining
pertaining1347993pertaining
pining93726533__pining
plaiting113113513plaiting
planing103418253pla_ning
planning113610223planning
prancing132612163prancing
pranging123012723pranging
pranking153813383pranking
prating103424453pra_ting
praying133717323pra_ying
preening113115843preening
pretraining1446503pretraining
pricing123417343pr_icing
priding113317543pr_iding
priming123417373pr_iming
prinking153212453pr_inking
printing113216083pr_inting
prising103321453pr_ising
prizing193514683pr_izing
propining14310133propining
pruning10311733pr_uning
quailing1838403quailing
quoining1835893quoining
racing95030533_ra_cing
racking144323663_racking
radding103715003_radding
radioing1039383_radioing
rafting113815753_rafting
ragging103516683_ragging
raging85126433_ra_ging
railings93412153_railings
rainier71614263_rainier
rainily10310433_rainily
raisin62716923_raisin_
raisings9338443_raisings
raisins72715343_raisins
raisiny10319923_raisiny
raking114728423_ra_king
ramming123115063_ramming
ramping123316873_ramping
ranging94120263_ranging
ranking124320883_ranking
ranting84025413_ranting
raping94829853_ra_ping
rapping123619103_rapping
raring74332873_ra_ring
rasing74330833_ra_sing
rasping104316253_rasping
rating74938703_ra_ting
rationing1039783_rationing
ratting83822363_ratting
ravening122611293_ravening
raving105128853_ra_ving
raxing144321023_ra_xing
raying105027193_ra_ying
razing164524543_ra_zing
razzing1636323_razzing
refining122416863refining
refraining1437263refraining
regaining112411083regaining
reigning1039883_reigning
reinking13311023_reinking
reiving113316843_reiving
relining93218743relining
remaining122212793remaining
repining114116593repining
reraising10313773reraising
resining92919553resining
restraining1247533restraining
retaining102114733retaining
ricing94822763_r_icing
riding84325963_r_iding
riling74227973_r_iling
riming93322223_r_iming
ringing93521283_r_inging
rinning83216743_rinning
rinsing82516113_r_insing
riping93821613_r_iping
rising74025883_r_ising
riving104521423_r_iving
roiling83220453_roiling
rosining92411423rosining
running83514593_running
sailing83927373_sailing
sainting93215733_sainting
saning75127643_sa_ning
sardining1137573sardining
scanning113310773scanning
seining84020773_seining
shining113816523_shining
shrining122610853shrining
skeining1347073skeining
snailing92912973snailing
spanning113311083spanning
spawning14296913spawning
splining11310773splining
staning83922243sta_ning
strafing122111193stra_fing
straitening1243663straitening
stranding1149653stranding
strapping1436993strapping
strawing122411623stra_wing
straying122912693stra_ying
striating10914193striating
striding102713603str_iding
striking133012233str_iking
stringing1139753str_inging
striping112612523str_iping
striving122611393str_iving
swanning12338813swanning
tabbing123611913t_abbing
tabling103216033t_abling
tabuing10308893t_abuing
tacking144421483t_acking
tagging103014913t_agging
tailings93211673t_ailings
taking114725953t_a_king
talcing103111633t_alcing
talking123815823t_alking
taming94023433t_a_ming
tamping122815813t_amping
tanging93419523t_anging
tanking123918793t_anking
tannin62613923t_annin_
tannings9268633t_annings
tannins72813223t_annins
taping94222393t_a_ping
tapping123317133t_apping
tariffing1644113tariffing
taring73932283t_a_ring
tarring83318303t_arring
tarrying12146723tarrying
tarting84222653t_arting
tasking124616323t_asking
tasting84624213t_asting
tatting84019523t_atting
taunting93510933t_aunting
tauting83316383t_auting
tawing104521553t_a_wing
tawsing1138673t_awsing
taxiing1535723t_axiing
taxing143816713t_a_xing
taxying1836183t_axying
teaching143612603teaching
teaming103917593tea_ming
tearing84021493tea_ring
teasing83918513tea_sing
teazling1856573teazling
tenoning938893tenoning
thacking183110043thacking
thanking16409523thanking
thawing14378683tha_wing
thinking16289863t_hinking
thinning12319093thinning
thorning1237513thorning
thralling13256833thralling
thrashing1635683thrashing
thrawing1535963thra_wing
thriving15246353thriving
throning1238863throning
tiding83520093t__iding
tieing73518763t__ieing
tiffining1642913tiffining
tiling73426553t__iling
timing93619303t__iming
tinging93619463t__inging
tinning83117283t_inning
tinting84620603t__inting
tiring74023093t__iring
toadying1335043toadying
toasting93410583toasting
toiling83219023t_oiling
toiting83217093t_oiting
tokening1336463tokening
toning74025793t__oning
trachling1537823trachling
tracings112910413tra_cings
trackings16247543trackings
traducing1374013traducing
trailering1145723trailering
train56529113tra__in_
trainband1243123trainband
trained84117203train_ed
trainee72817793train_ee
trainees82712063trainees
trainer73316793train_er
trainers83114643trainers
trainful1145183trainful
trainman1046233trainman
trainmen1046153trainmen
trains64725343tra__ins
trainway1444223trainway
trameling1249053trameling
tramline10311383tramline
trampling1436973trampling
trannies8415013trannies
tranny94210863tra_n_ny
transiting11410773transiting
trapanning1343213trapanning
trapesing1247263trapesing
trapline10411863trapline
trappings14265753trappings
travailing1444613travailing
traveling1349053traveling
treading103515333treading
treadling1137503treadling
treating92519613treating
trebling1139873trebling
treeing83414303tr_eeing
trekking1235543trekking
trending103012833trending
trepanning1344153trepanning
trephining1644933trephining
triazin1638203triazin_
triazine1738503triazine
triazins1738353triazins
tricking152714513tricking
trifling122411503trifling
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trindling1137133tr_indling
trinity10310843tr_inity
tripling112712553tripling
tripping133210923tripping
trithing122811773trithing
troaking133310973troaking
trocking153612423trocking
troking123514103tr_oking
trolling93212493trolling
tromping13319603tromping
trooping112710283trooping
trothing122410843trothing
trotting92510913trotting
trouncing1235153trouncing
trouping11249503trouping
trowing113413703tr_owing
truanting1035603truanting
trucing103211843tr_ucing
trucking153310163trucking
trudging11266443trudging
trueing83410183tr_ueing
truing73913933tr__uing
trumping13308733trumping
trussing9268653trussing
trusting93411653trusting
trying104214073tr__ying
trysting12267053trysting
tuning74016843t__uning
tunning83514453t_unning
turning83713183t_urning
twanging13287063twanging
twinging13278423t_winging
twinning12367043twinning
tyning105510413t__yning
upraising1237263upraising
vailing113817953_vailing
vanning113912463_vanning
veining114713893_veining
vining104619463__vining
waifing142910893_waifing
wailing113620903_wailing
wairing113414313_wairing
waiting113618953_waiting
waiving14329633_waiving
waning103623803_wa_ning
wanning113816213_wanning
warning113717093_warning
weaning114117193wea_ning
whining143311673_whining
wining103625053__wining
wracking18349963wracking
wrapping16297623wrapping
wrathing15248923wrathing
wringing13279623wr_inging
writing113713893wr_iting
yarning113512953_yarning
yawning14378343_yawning
yeaning113814633yea_ning
yearning1296983yearning

Search took 10 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.423422437.4
2DLD Change Limit1461625208.73316736.7
3Display Results5205200.2202363.6
 (SQL Overall)1786915209.37619058.3
 
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.