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

287 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
pistole9241431(None) 
pistol83313331pistol_
pistoled11259591pistoled
pistoles102514721pistoles
pistols93213981pistols
citole8311502ci_tole
diastole947562diastole
distome10313232distome
epistle957892epist_le
epistoler1143742epistoler
epistome1246262epistome
epistyle1364072epistyle
histone10312842histone
istle52214712_ist_le
pesthole1347552pesthole
pestle83215842pest_le
piehole12188552piehole
pinhole122010432pinhole
pinole83218782pi_nole
pintle83818262pint_le
pishoge1336692pishoge
piste75824602pist__e
pistil83915072pistil_
pistils93314302pistils
pistoleer1144312pistoleer
pistolero1163642pistolero
pistolier1146382pistolier
pistolled1255172pistolled
piston83515922pisto_n
pistons93016372pistons
pistou83211842pisto_u
pistous92714382pistous
posole8314222pos_ole
posthole1339532posthole
pustule937682pustule
rissole739782rissole
stole54928812__stole
systole1035762systole
airhole1048273airhole
aisle55223193ais__le
anisole71010833anis_ole
apostle937853apost_le
asshole1046793asshole
bastile9313913bastile
biotope1146623biotope
bistate9313823bistate
bistort91216523bistort
bistre83815023bist_re
bristle91910103brist_le
bristol937043bristol_
bristols1046773bristols
bustle84015483bust_le
castle84918963cast_le
cestode1037963cestode
cineole91010003cineole
citola838393ci_tola
citoles9312553ci_toles
diastoles1047493diastoles
diazole1736793diazole
dipole91112853di_pole
disable10516433disable
dispose10312763dispose
disrobe1038993disrobe
dissolve1246103dissolve
distal73615773distal_
distil73616433distil_
distill83011323distill
distils83015803distils
distomes11314163distomes
distort81120333distort
disyoke1546233disyoke
episcope1445833episcope
episode1056303epis_ode
episome1157813epis_ome
epistler1044833epist_ler
epistles1047783epist_les
epistolers1243183epistolers
epistomes1346013epistomes
epistyles1454143epistyles
epitome1157743epi_tome
epitope1147053epi_tope
eustele738193eustele
fictile1238023fictile
fishpole1644053fishpole
fissile10269653fissile
fistnote1144323fistnote
fistula1045503fistula
fistulae1144533fistulae
gristle8169223grist_le
histogen1245563histogen
histoid1139823histoid
histones11312803histones
history1339423history
hostile10312553hostile
hustle93113993hust_le
indole74516053_indole
insole63515863_insole
intone61115433_intone
isle45121703_is__le
isotone7239983_isotone
isotope9227783_isotope
istles62814983_ist_les
ixtle12168013_ixt_le
jostle13319863jost_le
justle133211583just_le
kirtle10309473kirt_le
kittle104012173ki_ttle
lintol6369473lintol_
lintols7339553lintols
lisle53916723lis__le
lissome937583lissome
listable10810313listable
listee64223063list_ee
listel64214743listel_
listels74212433listels
little63312163li_ttle
midsole1037813midsole
misatone1049763misatone
miscode12310413miscode
misdone10310863misdone
misfile122611553misfile
mismove1437083mismove
misrule939353misrule
missile92815403missile
misstyle1345273misstyle
mistake131312623mistake
mistily122612343mistily
mistime11312613mistime
mistitle1038523mistitle
mistook1337153mistook
mistune9310653mistune
mistype14126523mistype
misyoke1635823misyoke
nestle63013953nest_le
oilhole1046263oilhole
oilstone847273oilstone
osmole8128513_osmole
ostiole739013_ostiole
outsole71013433outsole
pantile93918483pantile
pantofle1364553pantofle
parole84425253p_arole
paste74932953past__e
pastel85918713pastel_
pastels95215183pastels
pastie85525523past_ie
pastil85018323pastil_
pastille1038943pastille
pastils94416173pastils
pastime114611973pastime
pastor84817483pasto_r
pastorale1147323pastorale
pastored1139973pastored
pastorly1345783pastorly
pastors94119003pastors
pasture9311463pasture
pentode1039893pentode
pentose9311593pentose
peptone11310763peptone
peristome1346593peristome
peristyle1444303peristyle
pestholes1448233pestholes
pestled102711453pest_led
pestles93217693pest_les
pesto75723723pesto__
pestos84719083pesto_s
petiole9311303petiole
pettle84116053p_ettle
phytol14366563phytol_
phytols15276553phytols
piastre9307893piast_re
piccolo1354403piccolo
pickle144215653pi_ckle
picomole1445723picomole
picotee11311473picotee
picture1158613picture
piddle103514913pi_ddle
pieholes13168913pieholes
piffle14418233pi_ffle
pignoli1045443pignoli
pile65649693pi___le
pilose84514243pi_lose
pilule8411123pi_lule
pimple123512963pi_mple
pinbone1138183pinbone
pinfold1336233pinfold
pinholes131810663pinholes
pinitol936683pinitol_
pinitols1046103pinitols
pinnule936003pinnule
pinocle1138143pinocle
pinoles93418703pi_noles
pintles94118723pint_les
pinto75625753pinto__
pintoes95117713pintoes
pintos86021293pinto_s
pinwale1257843pinwale
piolet83225643pi__olet
pipestone1345503pipestone
piscine11610973piscine
pisco96314983pisco__
piscos105112593pisco_s
pishoges1446953pishoges
pishogue1442833pishogue
pismire1135353pismire
piso66727563pis_o__
pisolite10310373pis_olite
pisos76021063pis_o_s
pissoir945043pissoir
pistache1545893pistache
pistes85325633pist_es
pistoleers1243793pistoleers
pistoleros1262863pistoleros
pistoliers1244583pistoliers
pistoling1268493pistoling
piton76121583pi_to_n
pitons85319043pi_tons
pizzle16279493pi_zzle
plimsole1243663plimsole
pole65951303p___ole
porthole1349523porthole
posable112212783posable
posoles9314883pos_oles
postage103214853postage
postal84317533postal_
postals93716383postals
postcode1346323postcode
postholes14410453postholes
postie84123963post_ie
postop10511943posto_p
postops11311713postops
postpone1248693postpone
postpose1247653postpose
posture9313253posture
pothole12312173pothole
potstone1039423potstone
pottle84416103p_ottle
pozole1758913p_ozole
prattle9208833prattle
prestore104217353prestore
pretold1049083pretold
pristane10310343pristane
pristine10313503pristine
prole74527793p__role
prostyle13187273prostyle
protyle12229453protyle
psoae74411623p_s_oae
pustuled1134953pustuled
pustules1038443pustules
pyrrole1246033pyrrole
resole64624183res_ole
restoke116113903restoke
restore75822983restore
restyle1038763restyle
risible937923risible
rissoles839113rissoles
rustle63615413rust_le
skatole1135693skatole
sole46053673__s_ole
spittle937923spi_ttle
stale55637103__stale
stele55026843__stele
stile54931573__stile
stoae55024263__stoae
stoke94922513__stoke
stoled74521593__stoled
stolen64315063__stolen
stoles63927673__stoles
stone55431183__stone
stope74727243__stope
store56333813__store
stove85220253__stove
style85519363__style
systoles1146483systoles
thistle10107803thist_le
tinstone848173tinstone
tiptoe838283tipto_e
title54721073ti_t_le
tittle63613323ti_ttle
tole46052903___tole
viscose1237863viscose
visible1236923visible
vittle94711753vi_ttle
whistle13107533whist_le
wintle94014603wint_le
wittol935923wittol_
wittols1035733wittols

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.453394461.4
2DLD Change Limit1340272876.81319672.2
3Display Results2872870.1102609.1
 (SQL Overall)1786912877.37624226.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.