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

357 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
bastiles1031335(None) 
bastile9313911bastile_
bastilles1147351bastilles
astilbes1044732_astilbes
banties94324762banti_es
baptises1238922baptises
baptizes2136842baptizes
bascules1236682bascules
basils85717472bas_il_s
bastes85330382bast__es
bastille1047992bastille
bastings114214692bastings
bastions10411692bastions
battles94517682ba_ttles
bawties124214312bawti_es
beasties102514652beasti_es
besmiles1237392besmiles
blasties102113632blasti_es
bustles93816322bust_les
castles94917732cast_les
hostiles11312212hostiles
mastixes1738252mastixes
nasties73520492nasti_es
pantiles103617152pantiles
pasties94529812pasti_es
pastilles1148702pastilles
pastils94416172pastil_s
pastimes123611902pastimes
pastises103616052pastises
stiles64328772__stiles
abatises10311013abatises
abattises1155083abattises
abscises1246233abscises
abseiled1144733abseiled
abseils935973abseil_s
actives12311523_actives
aediles83413903_aediles
articles10310243_articles
ascites9312603_ascites
asides75118873_as_ides
aspires9612043_aspires
aspises9611643_aspises
assizes1638453_assizes
astilbe945653_astilbe
attires72312953_attires
audiles83112613_audiles
babbles104416323ba_bbles
babies106123653ba_bi_es
baddies114017873baddi_es
baffies153612943baffi_es
baffles153710683ba_ffles
baggies113814853baggi_es
bagpipes1543403bagpipes
bailed94726653ba__iled
bailee84526013ba__ilee
bailees93914383ba__ilees
bailer85425253ba__iler
bailers94221353ba__ilers
bailey115015673ba__iley
baileys12388933ba__ileys
bailies94120203ba__ilies
bails75933523ba__il_s
baizes174315053ba__izes
baldies105317703baldi_es
bales76250083ba___les
ballies93725743balli_es
bandies104124863bandi_es
bangles103617413ba_ngles
banshies131110663banshi_es
baptise1139553baptise_
baptised1335263baptised
baptisms1446033baptisms
baptists1236723baptists
baptize2036983baptize_
baptized2245483baptized
baptizer2134893baptizer
baptizers2243443baptizers
barbies114519593barbi_es
barbules1238043barbules
barflies1338303barflies
barites94322333ba_rites
basaltes10367683basaltes
basalts9358963bas_alts
bascule1136573bascule_
baseless1099563bas_eless
baselines1138603baselines
bases75644353bas___es
bashes115631393bas__hes
bashings144311243bashings
basics104915123bas_i_cs
basifies13310493basifies
basil75122273bas_il__
basilar937303bas_ilar
basilect1245903bas_ilect
basilects1342973bas_ilects
basilic1137493bas_ilic
basilisk1444053bas_ilisk
basined10310003bas_ined
basinet9318933bas_inet
basinets1039063bas_inets
basins85722763bas_i_ns
basions94213953bas_ions
basis75429863bas_i__s
basophiles1744783basophiles
basques18248673bas_ques
basses85428303bas__ses
bassinet10312843bassinet
bassinets1146323bassinets
bassists1037183bassists
bastards113310313bastards
baste74829983bast__e_
basted95227233bast__ed
baster85333593bast__er
basters94930303bast_ers
bastinades1344603bastinades
basting104227203basti_ng
bastion9312473basti_on
bastioned1246863bastioned
basts75936933bast___s
batches144019613ba_tches
bates75846343ba_t__es
bathes116524833ba_t_hes
bathless13127383ba_thless
batiked1435963ba_tiked
batiks1239373ba_ti_ks
batistes1039713ba_tistes
battier93515713batti_er
battiest104115553batti_est
battiks1337143batti_ks
battiness11239843battiness
battings114010573battings
battle85217863ba_ttle_
battled104213123ba_ttled
battler94113383ba_ttler
battlers104110973ba_ttlers
battues94610193ba_ttues
baubles113611863ba_ubles
bauxites1735153bauxites
bawdies134613393bawdi_es
bawtie113812143bawti_e_
beastie92412433beasti_e_
beastings12387653beastings
beastlier1144193beastlier
beastliest1244663beastliest
beauties10229523beauti_es
bedtimes1336593bedtimes
beetles9312083beet_les
beguiles1146103beguiles
besides104814533bes_ides
beslimes1246953beslimes
besmile1137463besmile_
besmiled1335493besmiled
bestirs9311133besti_rs
bestrides1237913bestrides
betides104915263b_etides
betimes115114413b_etimes
betises94816123b_etises
bhisties1339003bhisti_es
biles75542143b___iles
biotites10310083biotites
bistres94017213bist_res
blastie92411393blasti_e_
blastier10249493blasti_er
blastiest111710043blasti_est
blastings12347913blastings
blastulas1143593blastulas
booties94124613booti_es
bossies94116833bossi_es
bottles94216273b_ottles
brasils9410973bras_il_s
brassies103613533brassi_es
brattices1345553brattices
brattles10199333brattles
bristles101510433brist_les
brittles10178653brittles
busbies113011693busbi_es
busies85525263bus_i_es
bustics11810883busti_cs
bustier93916153busti_er
bustiers103810053bustiers
bustiest102815053busti_est
bustiness111810473bustiness
bustle84015483bust_le_
bustled104011513bust_led
bustler94012563bust_ler
bustlers104210613bust_lers
bustlines11207353bustlines
butles84423913b_ut_les
butties93217953butti_es
canticles1339183canticles
cantles94721413cant_les
captives1538623captives
cassines103116613cassines
cassises103811743cassises
castes85631863cast__es
castings113614053castings
castle84918963cast_le_
castled104311513cast_led
catties94023053catti_es
centiles103615813centiles
chastises1437703chastises
cystines1339473cystines
dartles84014133dart_les
dassies84418663dassi_es
datives11310073da_tives
dauties83315763dauti_es
dawties113312703dawti_es
daytimes1434483daytimes
destines93619663destines
diastoles1047493diastoles
distills9319043distills
distils83015803distil_s
easies64126633eas_i_es
eastings93412953eastings
ensiles72714833ens_iles
eusteles838043eusteles
fascicles1664263fascicles
fascines13310143fascines
fastings124011943fastings
fatties103018203fatti_es
gentiles93713523gentiles
hantles104117513hant_les
hassles103411693has_sles
hastes95727073hast__es
hastier103916623hasti_er
hastiest112916493hasti_est
hastily133010663hastil_y
hastiness122410883hastiness
hostile10312553hostile_
hustles103414173hust_les
instills867353instills
instils7811453instil_s
isatines8310663isatines
istles62814983_ist_les
jasmines1736623jasmines
jostles143411143jost_les
justices1737523justices
justles143311433just_les
kanteles1238123kanteles
laetriles944663laetriles
laities7320343laiti_es
lassies74420103lassi_es
lastings94214423lastings
latices9313763la_tices
lattices1038383lattices
mailes84329113ma__iles
mantises10317923mantises
mantles94820703mant_les
mashies12318253mashi_es
mastiches1647333mastiches
mastics112614783masti_cs
mastiffs1644233mastiffs
mastitis1039103mastitis
mastless102610023mast_less
misfiles133110983misfiles
missiles103015083missiles
mistimes12612613mistimes
mistitles1147953mistitles
motiles93317433_motiles
nargiles976793nargiles
nastier74115293nasti_er
nastiest83615953nasti_est
nastily103011033nastil_y
nastiness92310573nastiness
natives10310823na_tives
nautilus844073nautilus
nestles73015463nest_les
ostioles839273_ostioles
panties94230933panti_es
pantile93918483pantile_
pantiled113111593pantiled
particles1339803particles
parties93230863parti_es
passives13228823passives
pastels95215183pastel_s
pastes85233913past__es
pastiches1637453pastiches
pastie85525523pasti_e_
pastier94320383pasti_er
pastiest103319543pasti_est
pastil85018323pastil__
pastille1038943pastille
pastime114611973pastime_
pastinas103712153pastinas
pastiness112312353pastiness
pastis84924323pasti__s
pastless102411203past_less
pastries101517423pastries
pastures10311963pastures
patines95225763pa_tines
patsies93919483patsi_es
patties93425143patti_es
pestles93217693pest_les
pistils93314303pistil_s
pistoles102514723pistoles
posties93128813posti_es
pustules1038443pustules
quantiles1846603quantiles
quartiles1845603quartiles
ragtimes1135823ragtimes
ramtils938413ramtil_s
rassles73513923ras_sles
ratines75328583ra_tines
ratites74920683ra_tites
rattles73217303ra_ttles
reptiles103913063reptiles
resiles74026543res_iles
restyles1139193restyles
retiles74426993_retiles
rustles73416413rust_les
rutiles74315843_rutiles
salties73725773salti_es
saltines82917793saltines
saltires83112423saltires
sassies74719263sassi_es
satires72617573sa_tires
sestines82717243sestines
sextiles1537643sextiles
smiles84522293__smiles
spiles84227913__spiles
stales65538293__stales
steles63725663__steles
sties55132983__sti_es
stifles103013393__stifles
stile54931573__stile_
stills64118573__stills
stilts67915313__stilts
stimes85920573__stimes
stipes84524053__stipes
stoles63927673__stoles
styles94418653__styles
systoles1146483systoles
tactile9310613tactile_
tassies74918933tassi_es
tasteless935673tasteless
tastes64126423tast__es
tastier711817093tasti_er
tastiest83216633tasti_est
tastily103311643tastil_y
tastiness92311143tastiness
tatties74120343tatti_es
tattles73616283ta_ttles
testicles1146773testicles
textiles1536833textiles
tiles55542103___tiles
vastier103613203vasti_er
vastiest112713073vasti_est
vastities1248933vastities
vestiges1238243vestiges
warstles11368803warst_les
wartimes1336963wartimes
wastages12109753wastages
wastes96224883wast__es
wastrels1136203wastrels
wastries111212883wastries
wattles103814073wa_ttles
wrastles11328933wrast_les

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623576.73321708.3
3Display Results3573570.1402550.0
 (SQL Overall)1786913577.02925422.0
 
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.