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

171 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
entrain731307(None) 
engrain838351engrain
entrains8312961entrains
detrain8412252detrain
enchain1248852enchain
endbrain1144182endbrain
endrin7312402endr_in
engrail846262engrail
engrains937582engrains
entail61114342ent_ail
entertain947862entertain
entrails8310162entrails
entrained1089412entrained
entrainer968582entrainer
entrant7318872entrant
entrap8710562entra_p
entraps9109762entraps
estrin6315922estr_in
ingrain839522ingrain
restrain8311702restrain
retrain7615422retrain
seatrain847922seatrain
strain64919572_strain
train56529112__train
vitrain1038942vitrain
antiair7310313antiair
antiarin8413893antiarin
antra56521923antra__
antral65719413antra_l
anuran64313243anura_n
attain6311753_attain
atwain937813_atwain
brain76229383__brain
cantraip12326393cantraip
centai84814783cent_ai_
centra84113883centra__
central93114473centra_l
centrals102712033centrals
centric11312403centr_ic
centring112112953centr_ing
centroid1159303centroid
certain92612213cert_ain
citrin82615413citr_in
constrain1149323constrain
contain9315833cont_ain
contrail10410973contrail
curtain9319793curtain
dentin73919573dent__in
destain8412083dest_ain
detain74617383det_ain
detrains9411763detrains
dextran1586163dextra_n
dextrin1587543dextr_in
distrain9412243distrain
drain65222893__drain
elain55324703e__lain
enchains1348523enchains
endbrains1244063endbrains
endrins8312163endr_ins
energid948303energid
enframe1247363enframe
enframing1546113enframing
engraft11118613engraft
engrails945383engrails
engrained1145493engrained
engram9310653engra_m
engrams1038073engrams
engrave1137133engrave
engraving1446013engraving
enjoin1357833en_join
enrage72715073en_rage
enraging1049573en_raging
enrapt8313013en_rapt
entails7912823ent_ails
entasia73110063entasia
entasis73012573entasis
entera64216833entera__
enteral73516433entera_l
enteric9314213enteric
entering91920053entering
enteron7313333enteron
entertains1047623entertains
enthral103410933enthra_l
enthrall11266833enthrall
enthrals11278903enthrals
entia5318203ent__ia
enticing11311803enticing
entoil6912493ent_oil
entopic1149953entopic
entrainers1086963entrainers
entraining1147643entraining
entrance10311323entrance
entrancing1346783entrancing
entrants8311753entrants
entrapping1544873entrapping
entreat7315263entreat
entreating11811553entreating
entreats839773entreats
entreaty1146173entreaty
entree61817883entr_ee
entrees71813773entrees
entries71523163entries
entropic1249683entropic
entropion11106283entropion
entropy1247353entropy
entrust7410883entrust
entry82414263entr__y
entwine1039143ent_wine
enuring8813883enur_ing
enwrap1185213enwra_p
enwraps1284833enwraps
estragon944793estragon
estral64716513estra_l
estray95713333estra_y
estraying1338293estraying
estrays10529403estrays
estrins7315853estr_ins
etamin81311853e_tamin
explain1667043explain
extra1239003extra__
extract16311013extract
extras13310223extra_s
eyestrain1243433eyestrain
gentian8310103gentia_n
grain65126253__grain
indrawn1145093indrawn
ingrains948983ingrains
intrant7318753intrant
introit7414533introit
intron64215023intr_on
mistrain10311943mistrain
murrain937763murrain
obtain839183obt_ain
oestrin7312243oestr_in
outgain81010743outgain
outlain71212613outlain
outran63218893outra_n
overtrain1259783overtrain
pertain92714963pert_ain
pretrain10310923pretrain
quatrain1745823quatrain
rain46251733___rain
reattain846733reattain
refrain10310043refrain
restrains9311623restrains
restraint9412753restraint
retain64523283ret_ain
retrains8314533retrains
seatrains947603seatrains
sextain14257093sext_ain
sprain83614863_sprain
stain55727933_st_ain
strains74218153_strains
strait64025893_strait
tain45548073__t_ain
terrain7410843terrain
traik95418203__traik
trail55126773__trail
trains64725343__trains
trait56940843__trait
twain86313623__twain
unbraid1037183unbraid
unchain1238943unchain
undrawn1145293undrawn
untrack1338703untrack
untrained10510993untrained
untrim8310673untr_im
ventail10310453vent_ail
ventral103612173ventra_l
ventrals112910003ventrals
vitrains1138283vitrains

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.236757165.3
2DLD Change Limit1340271716.95319276.1
3Display Results1711710.0762250.0
 (SQL Overall)1786911717.26524596.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.