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

161 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
trainings1024672(None) 
training93015861training_
braidings13285902braidings
braining113414682braining_
draining103312672draining_
graining102813182graining_
railings93412152_railings
raining83922692_raining_
raisings9338442_raisings
straining10410562straining_
tailings93211672t_ailings
tannings9268632t_annings
tracings112910412tra_cings
trackings16247542trackings
traiking132511972traiking_
trailing92916092trailing_
trappings14265752trappings
trining82919212tr_ining_
airings83913843__airings
arginines1047053arginines
attaining1047223attaining_
awnings11406713__awnings
bracings13369293bra_cings
braiding123112703braiding_
brailing113514793brailing_
brainiacs1343773brainiacs
braininess1246123braininess
braising113014563braising_
brandings13277483brandings
branning112911093branning_
brining103216473br_ining_
cannings113710333_cannings
chaining142810783chaining_
crackings18346843crackings
craning103620303cra_ning_
cravings14428223cra_vings
cruisings12214113cruisings
darnings10378553_darnings
detraining1267673detraining_
draftings14334203draftings
drawings13386283dra_wings
drinkings15244773dr_inkings
drivings13265763dr_ivings
earnings9419333_earnings
entraining1147643entraining_
failings123811013_failings
fairings12388193_fairings
finings114311773__finings
fraggings15324243fraggings
framings14338133fra_mings
frayings15325993fra_yings
gaining94015663_gaining_
graininess1145793graininess
gratings103910763gra_tings
graylings1433883graylings
grazings19337263gra_zings
greenings11266663greenings
groining102310633groining_
ironings9217583ir_onings
joinings16285243_joinings
leanings94010183lea_nings
learnings1094323learnings
linings84313073__linings
loanings9348013loa_nings
mailings113011923_mailings
meanings11329163mea_nings
minings103912073__minings
ordaining1145753ordaining_
paining103920243_paining_
paintings12327093_paintings
pairings11398313_pairings
plaining113911553plaining_
plaitings12296243plaitings
plannings12325453plannings
praising113214563praising_
prawning1446963prawning_
primings13338143pr_imings
printings12268103pr_intings
racings105015133_ra_cings
raiding93617593_raiding_
railing83325643_railing_
raininess949273_raininess
raising83220533_raising_
raisins72715343_raisin_s
rankings13389173_rankings
raspings11337853_raspings
ratings84217413_ra_tings
ravenings13235183_ravenings
ravings114614503_ra_vings
ravining12269693_ravining_
reining84425323_reining_
retraining11310243retraining_
ridings93412093_r_idings
rinsings9318013_r_insings
risings83211893_r_isings
ruining83514883_ruining_
runnings9326913_runnings
sailings93513253_sailings
saining83621393_saining_
scannings12264823scannings
spraining1248153spraining_
staining9413373staining_
strappings1543353strappings
stringings1245233str_ingings
stripings12215203str_ipings
tailing82923103t_ailing_
tainting93613583t_ainting_
takings124512573t_a_kings
talkings13358403t_alkings
tanning83618253t_anning_
tannins72813223t_annin_s
tappings13267713t_appings
tattings9408823t_attings
teachings15296553teachings
thinkings17255053t_hinkings
thrashings1742783thrashings
tidings93810263t__idings
tilings84212793t__ilings
timings10279303t__imings
tining74927543t__ining_
tintings9288713t__intings
tracing103720153tra_cing_
tracking153715463tracking_
trading93517973tra_ding_
trailerings1242943trailerings
trainbands1352653trainbands
trainees82712063train_ees
trainers83114643train_ers
trainfuls1243953trainfuls
trains64725343tra__in_s
trainways1543023trainways
traipsing1235073traipsing_
tramlines1139843tramlines
tramming13279343tramming_
tramping132711273tramping_
trancing112812023trancing_
trannies8415013tranni_es
traplines11310373traplines
trapping132911393trapping_
trashing122613223trashing_
trawling122710783trawling_
triaging102610543triaging_
triazines1847543triazines
triazins1738353triazin_s
tricing103417353tr_icing_
triflings13235973triflings
trimmings14254453trimmings
trippings14225723trippings
trithings13246603trithings
trollings10286693trollings
truckings16235023truckings
trussings10224033trussings
turnings9287233t_urnings
twining113211443t_wining_
twinnings13253663twinnings
veinings12306433_veinings
waitings123413743_waitings
warnings12358453_warnings
wrappings17253713wrappings
writings12298113wr_itings
yearnings1393553yearnings

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.406440125.6
2DLD Change Limit1486411617.65619415.0
3Display Results1611610.0632555.6
 (SQL Overall)1786911618.12521992.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.