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 “train” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 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
train5652911(None) 
brain76229381brain
drain65222891drain
grain65126251grain
rain46251731_rain
strain64919571strain
tain45548071t_ain
traik95418201traik
trail55126771trail
trains64725341trains
trait56940841trait
twain86313621twain
again65218122again
ain37579092__ain
amain74922912amain
attain6311752attain
atwain937812atwain
blain75421792blain
braid85822262braid
brail75525552brail
brains85125472brains
brainy114815642brainy
bran65740382bra_n
brawn106018562brawn
brin67038192br_in
bruin75818332bruin
cain65643912_cain
chain105723672chain
detrain8412252detrain
drail65020972drail
drains73719402drains
drawn95614242drawn
elain55324702elain
entrain7313072entrain
fain75840562_fain
frail85220212frail
gain56042162_gain
gradin83517482gradin
grail64622872grail
grains74223092grains
grainy103914212grainy
gran56335012gra_n
gratin74520582gratin
grin55733722gr_in
groin65521082groin
kain85334292_kain
krait94726772krait
lain46146282_lain
main65345522_main
orcin72716572orcin
ordain7810402ordain
orpin73415532orpin
pain65647242_pain
plain74823302plain
prawn105312432prawn
rai37658222_rai_
raia46638382_raia
raid55243072_raid
rail46147762_rail
rains55140232_rains
rainy85921082_rainy
rais45252622_rais
ran38266622_ra_n
rani46640112_rani
ravin85624652_ravin
rawin85521472_rawin
rein46040892_rein
retrain7615422retrain
rin36663182_r_in
ruin47430512_ruin
sain45551292_sain
sarin55239252sarin
slain54923572slain
sprain83614862sprain
stain55727942stain
strains74218152strains
strait64025892strait
swain84919052swain
tail45443652t_ail
tains54936322t_ains
taint55542282t_aint
takin94921302takin
tan37167572t_a_n
taring73932282taring
tarn46842722t_arn
terai53525482terai_
terais64023512terais
terrain7410852terrain
than76128772tha_n
thein85919022thein
thin76732392t_hin
thrawn12769422thrawn
tin36362172t__in
toxin124716712toxin
trace75829612trace
tracing103720152tracing
track114823012track
tract75635712tract
trad55630912tra_d
trade65026042trade
trading93517972trading
tragi64717172tragi
tragic93811552tragic
traiks104013712traiks
trails64622512trails
trained84117202trained
trainee72817792trainee
trainer73316792trainer
traits65121982traits
tram67034552tra_m
tramp96319772tramp
trams75327672trams
trank96222422trank
tranny94210862tranny
tranq145416892tranq
trans54933042trans
trap67532802tra_p
trapan82412972trapan
traps75727482traps
trapt76433392trapt
trash86119762trash
trass56226472trass
trave85223032trave
trawl84915872trawl
tray77632592tra_y
trays85623432trays
treen55622752treen
triac74116372triac
triad65217722triad
trial54926352trial
triazin1638202triazin
trig55528162tr_ig
trim65329522tr_im
trine54734602tr_ine
trio45233342tr_io
trip66830392tr_ip
trois57226092trois
tropin83316752tropin
truing73913932truing
trying104214072trying
twains95811182twains
twin76023082t_win
tyin76424002t_yin
vain75233002_vain
vitrain1038942vitrain
wain75840202_wain

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001461.59633709.3
3Display Results1461460.0463173.9
 (SQL Overall)1786911461.95291542.5
 
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.