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

345 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
trainee7281779(None) 
trained84117201trained
trainees82712071trainees
trainer73316791trainer
brained103816102brained
drained93713252drained
drainer83012842drainer
grained93814272grained
grainer83714062grainer
gratinee93710782gratinee
rained75024602_rained
ranee55438102_ra_nee
retrainee9511162retrainee
strained9412252strained
strainer8512222strainer
traiked123310452traiked
trailed83415672trailed
trailer73015392trailer
train56529112train__
trainers83114652trainers
trainmen1046162trainmen
trains64725342train_s
traipse935872traipse
trance84718762tra_nce
triene64316382tr_iene
trine54734602tr_in_e
trined74920712tr_ined
trines64132562tr_ines
arsine64021043arsin_e
arsines73518833arsines
atrazine1748403atrazin_e
atrazines1846683atrazines
attained997353attained
attainer8116913attainer
bailee84526013_bailee
braided114013213braided
braider105112993braider
brailed103914013brailed
braille939713braille
brain76229383brain__
brainier102510233brainier
brains85125473brain_s
brainy114815643brain_y
braise84318753brai_se
braised104014803braised
braises93818873braises
braize174113113brai_ze
braizes183112453braizes
branned104311693branned
branner94212373branner
bribee104316363br_ibee
brine75132273br_in_e
brined95118413br_ined
briner84519043br_iner
brines85028853br_ines
carinae94318593carinae
chaine115119223chain_e
chained133812693chained
chaines124518733chaines
crane75331603cra_n_e
craned96121653cra_ned
cranes84330753cra_nes
cringe93515483cr_inge
detainee92511723detainee
detrained1158913detrained
draftee11379523draftee
dragee84415603dra_gee
dragnet91211433dragnet
drain65222893drain__
drainage1045783drainage
drainers92811263drainers
drains73719403drain_s
drawee104413823dra_wee
entrained1089413entrained
entrainer968583entrainer
ermine8416923ermin_e
ermined10410603ermined
ermines9416673ermines
examinee17156583examinee
fainer94717243_fainer
frailer10319943frailer
fraise94214913frai_se
fraises104215693fraises
fringe104013953fr_inge
frisee94217993fr_isee
gained84617463_gained
gainer74117493_gainer
gradine93317033gradin_e
gradines103615253gradines
grain65126253grain__
grainers93012083grainers
grainier9218903grainier
grains74223093grain_s
grainy103914213grain_y
grandee93115513grandee
grange83716203gra_nge
granite82017083granite
grannie8310353grannie
grantee83217133grantee
grapnel1035603grapnel
gratine84719193gratin_e
gratineed11334473gratineed
gratinees10307323gratinees
groined92710813groined
larine63927043larin_e
marine84230413marin_e
mariner93316003mariner
marines93928033marines
matinee92415613matinee
moraine9314573morain_e
moraines10314373moraines
narine63422553narin_e
nominee9311583nominee
orange74016323ora_nge
ordained1035183ordained
ordainer945223ordainer
ordines83014903ordines
orpine83914483orpin_e
orpines94414793orpines
pained95622853_pained
pawnee113115403_pawnee
plained103812233plained
plainer93811983plainer
prairie938333prairie
praise84419413prai_se
praised104214813praised
praiser93413943praiser
praises94121113praises
praline93019743pralin_e
pralines102217733pralines
prance104318573pra_nce
prawned1346743prawned
prawner1246803prawner
prince104114763pr_ince
ragee65432663_ra_gee
raggee84217603_raggee
raided85017703_raided
raider74318743_raider
railed74727543_railed
railer64524933_railer
rain46251733_rain__
rainier71614263_rainier
rains55140233_rain_s
rainy85921083_rain_y
raise54828053_rai_se
raised76120333_raised
raiser66620103_raiser
raises64826543_raises
rakee96031173_ra_kee
ramee74633853_ra_mee
rance75028513_ra_nce
ranees64623963_ra_nees
range64728423_ra_nge
rapine85023083_rapin_e
rapines95120863_rapines
rappee103618673_rappee
ratine65131823_ratin_e
ratines75328583_ratines
ravine95522223_ravin_e
ravined115411823_ravined
ravines104220233_ravines
razee145827803_ra_zee
reined74425523_reined
retrained10411313retrained
retrainees1046393retrainees
rinse54820973_r_inse
ruined74813323_ruined
ruiner64013643_ruiner
sained75424243_sained
slainte738543slainte
sprained1138433sprained
stained84215343stained
stainer73614923stainer
strain64919573strain__
strainers9510403strainers
strains74218153strain_s
straiten838613straiten
straiter8311783straiter
strange85416343stra_nge
tailed74424663t_ailed
tailer63823733t_ailer
taille63116923t_aille
tain45548073t_ain__
tains54936323t_ain_s
taint55542283t_ain_t
tainted83512423t_ainted
taints64520533t_aints
tanned75219963t_anned
tanner63722293t_anner
taring73932283tarin_g
tawney12338233t_awney
terrine72517573terrin_e
terrines82117553terrines
thane86122533tha_n_e
thanes94918983tha_nes
theine94814923thein_e
theines104013233theines
thine85026863t_hin_e
tine45855143t__in_e
tinea54923163t__inea
tined65434533t__ined
tines54848423t__ines
tinge64626633t__inge
tirrivee1143613tirrivee
townee92815213t_ownee
toxine133114123toxin_e
toxines142912263toxines
trace75829613tra__ce
traced94821583tra_ced
tracer84820233tra_cer
traces85329933tra_ces
trachea12311683trachea
tracheae1349113tracheae
trachle12311853trachle
tracing103720153tracin_g
tracings112910413tracings
tracked143716133tracked
tracker133515173tracker
trade65026043tra__de
traded85717683tra_ded
trader75218763tra_der
trades75724503tra_des
trading93517973tradin_g
traduce1036353traduce
traik95418203trai__k
traiks104013713trai_ks
trail55126773trai__l
trailered1045393trailered
trailers82912933trailers
trails64622513trai_ls
trainable1138943trainable
trainful1145193trainful
training93015863training
trainman1046233trainman
trainway1444223trainway
traipsed1134753traipsed
traipses1036873traipses
trait56940843trai__t
traitor7310123traitor
traits65121983trai_ts
tramel84113713tra_mel
tramline10311383tramlin_e
tramlines1139843tramlines
trammed123810713trammed
trammel11357663trammel
tramped124312433tramped
tramper113812163tramper
trample11299703trample
tranced104414173tranced
trances93919643trances
tranche123312223tranche
trank96222423tra_n_k
tranks104017763tra_nks
trannies8415013trannies
tranny94210863tra_nny
tranq145416893tra_n_q
tranqs155210313tra_nqs
trans54933043tra_n_s
trapes85024463tra_pes
trapeze1836253trapeze
trapline10411863traplin_e
traplines11310373traplines
trapnest10310923trapnest
trapped124512213trapped
trapper113912803trapper
trashed113514703trashed
trasher104416133trasher
trashes104119263trashes
trasses74819323trasses
trave85223033tra__ve
travel94112983tra_vel
traves94222743tra_ves
trawled113411523trawled
trawler104011903trawler
trawley13317303trawley
trawlnet1146583trawlnet
tree47745813tr___ee
triable92515393triable
triage72812893tr_iage
triaged92810443triaged
triages82613793triages
triangle935533triangle
triazine1738503triazin_e
triazines1847543triazines
tribe74420273tr_i_be
tribes85119023tr_ibes
trice75127493tr_i_ce
triced95518673tr_iced
tricep103911073tr_icep
trices84826333tr_ices
tried65026913tr_i_ed
trienes74118413trienes
triens65417543tr_iens
trier54328533tr_i_er
tries55742813tr_i_es
trifle94012883tr_ifle
trijet133916553tr_ijet
trike95320163tr_i_ke
trikes105419493tr_ikes
trimer85717153tr_imer
trinal6516963tr_inal
trindle83311363tr_indle
trinket11314813tr_inket
triode75311893tr_iode
triose64715383tr_iose
tripe75425383tr_i_pe
tripes85324873tr_ipes
triple84215923tr_iple
trireme935263tr_ireme
triseme936543tr_iseme
triste63818643tr_iste
trite54730033tr_i_te
triter65120593tr_iter
triune64210183tr_iune
triunes74311383triunes
trivet93721883tr_ivet
trochee122613883trochee
trone55131863tr_on_e
trones65629283tr_ones
tropine93116653tropin_e
tropines102214923tropines
trounce936823trounce
truing73913933truin_g
trunnel745403trunnel
trustee73514443trustee
trying104214073tryin_g
turbine9310303turbin_e
turbines1039903turbines
turdine8310283turdin_e
twain86313623twain__
twains95811183twain_s
twine85822363t_win_e
twined104413123t_wined
twiner94012593t_winer
twines94717273t_wines
twinge104210403t_winge
tyramine1347303tyramin_e
tyramines1447213tyramines
untrained10510993untrained
uranide82212093uranide
uranite72515693uranite
urine55026603ur_in_e
urines64724123ur_ines
ursine64114123ursin_e
vainer93714573_vainer

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273457.00019146.7
3Display Results3453450.1262738.1
 (SQL Overall)1786913457.53223724.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.